Click here to Skip to main content
11,720,557 members (72,025 online)

Visual Basic

 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0114-Nov-12 3:48
membermaskrtnik0114-Nov-12 3:48 
GeneralRe: Rijndael encryption not working Pin
Keith Barrow14-Nov-12 4:05
mentorKeith Barrow14-Nov-12 4:05 
QuestionRe: Rijndael encryption not working Pin
maskrtnik0115-Nov-12 19:40
membermaskrtnik0115-Nov-12 19:40 
GeneralRe: Rijndael encryption not working Pin
DisIsHoody14-Nov-12 9:34
memberDisIsHoody14-Nov-12 9:34 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0114-Nov-12 18:21
membermaskrtnik0114-Nov-12 18:21 
AnswerRe: Rijndael encryption not working Pin
DisIsHoody15-Nov-12 17:37
memberDisIsHoody15-Nov-12 17:37 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0115-Nov-12 19:37
membermaskrtnik0115-Nov-12 19:37 
QuestionRetrive date from sql server in system date format in VB6 application by a one time setting Pin
Johnson Antony13-Nov-12 13:34
memberJohnson Antony13-Nov-12 13:34 
Hi,

My VB6 application has been developed long back using Access as back end. Now I am planning to migrate data from Access to sQL server 2008 .

1)Previously vb6 application was retrieving date from Access file in dd/MM/yyyy format which is the system format without any format function.(Uses RecordSet object) . After migrating to sQL server 2008 date retrieved in yyyy-MM-dd format which I have to format each time to my required format.

So it's creating issues at many places like inserting records to server, date comparison with date controls of vb6 etc. So I may have to apply format() function at many places. Can we use any once only setup to retrieve date in required format , so the application changes will be minimal. (at SQL Server side or at my application). ie the RecordSet.Open will always provide date data in dd/MM/yyyy format without any explicit formatting.

2)I am not able to use seek function with RecordSet object

Thanks in Advance
Johnson
AnswerRe: Retrive date from sql server in system date format in VB6 application by a one time setting Pin
Dave Kreskowiak13-Nov-12 14:00
mvpDave Kreskowiak13-Nov-12 14:00 
QuestionHow to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 7:47
memberKreativeKai13-Nov-12 7:47 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
Dave Kreskowiak13-Nov-12 8:09
mvpDave Kreskowiak13-Nov-12 8:09 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 8:22
memberKreativeKai13-Nov-12 8:22 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 8:46
memberKreativeKai13-Nov-12 8:46 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 8:13
memberKreativeKai13-Nov-12 8:13 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
Dave Kreskowiak13-Nov-12 9:57
mvpDave Kreskowiak13-Nov-12 9:57 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
Eddy Vluggen13-Nov-12 11:41
memberEddy Vluggen13-Nov-12 11:41 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai14-Nov-12 1:37
memberKreativeKai14-Nov-12 1:37 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
VitorHugoGarcia19-Nov-12 1:12
memberVitorHugoGarcia19-Nov-12 1:12 
QuestionVB Script for automatically turning off the monitor Pin
Prasan Cumar13-Nov-12 4:14
memberPrasan Cumar13-Nov-12 4:14 
AnswerRe: VB Script for automatically turning off the monitor Pin
Dave Kreskowiak13-Nov-12 4:59
mvpDave Kreskowiak13-Nov-12 4:59 
AnswerRe: VB Script for automatically turning off the monitor Pin
Bernhard Hiller13-Nov-12 21:20
memberBernhard Hiller13-Nov-12 21:20 
QuestionSQL Configuration Pin
DinoRondelly13-Nov-12 3:46
memberDinoRondelly13-Nov-12 3:46 
AnswerRe: SQL Configuration Pin
David Mujica13-Nov-12 4:07
memberDavid Mujica13-Nov-12 4:07 
GeneralRe: SQL Configuration Pin
DinoRondelly13-Nov-12 5:56
memberDinoRondelly13-Nov-12 5:56 
GeneralRe: SQL Configuration Pin
David Mujica13-Nov-12 9:44
memberDavid Mujica13-Nov-12 9:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 4 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid