Click here to Skip to main content
11,438,226 members (66,170 online)

Visual Basic

 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0114-Nov-12 4:48
membermaskrtnik0114-Nov-12 4:48 
GeneralRe: Rijndael encryption not working Pin
Keith Barrow14-Nov-12 5:05
mentorKeith Barrow14-Nov-12 5:05 
QuestionRe: Rijndael encryption not working [modified] Pin
maskrtnik0115-Nov-12 20:40
membermaskrtnik0115-Nov-12 20:40 
GeneralRe: Rijndael encryption not working Pin
DisIsHoody14-Nov-12 10:34
memberDisIsHoody14-Nov-12 10:34 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0114-Nov-12 19:21
membermaskrtnik0114-Nov-12 19:21 
AnswerRe: Rijndael encryption not working Pin
DisIsHoody15-Nov-12 18:37
memberDisIsHoody15-Nov-12 18:37 
GeneralRe: Rijndael encryption not working Pin
maskrtnik0115-Nov-12 20:37
membermaskrtnik0115-Nov-12 20:37 
QuestionRetrive date from sql server in system date format in VB6 application by a one time setting Pin
Johnson Antony13-Nov-12 14:34
memberJohnson Antony13-Nov-12 14: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 15:00
mvpDave Kreskowiak13-Nov-12 15:00 
QuestionHow to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 8:47
memberKreativeKai13-Nov-12 8:47 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
Dave Kreskowiak13-Nov-12 9:09
mvpDave Kreskowiak13-Nov-12 9:09 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 9:22
memberKreativeKai13-Nov-12 9:22 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 9:46
memberKreativeKai13-Nov-12 9:46 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai13-Nov-12 9:13
memberKreativeKai13-Nov-12 9:13 
GeneralRe: How to find out if a file is in use before reading the data in that file [modified] Pin
Dave Kreskowiak13-Nov-12 10:57
mvpDave Kreskowiak13-Nov-12 10:57 
AnswerRe: How to find out if a file is in use before reading the data in that file Pin
Eddy Vluggen13-Nov-12 12:41
memberEddy Vluggen13-Nov-12 12:41 
GeneralRe: How to find out if a file is in use before reading the data in that file Pin
KreativeKai14-Nov-12 2:37
memberKreativeKai14-Nov-12 2:37 
GeneralRe: How to find out if a file is in use before reading the data in that file [modified] Pin
VitorHugoGarcia19-Nov-12 2:12
memberVitorHugoGarcia19-Nov-12 2:12 
QuestionVB Script for automatically turning off the monitor Pin
Prasan Cumar13-Nov-12 5:14
memberPrasan Cumar13-Nov-12 5:14 
AnswerRe: VB Script for automatically turning off the monitor Pin
Dave Kreskowiak13-Nov-12 5:59
mvpDave Kreskowiak13-Nov-12 5:59 
AnswerRe: VB Script for automatically turning off the monitor Pin
Bernhard Hiller13-Nov-12 22:20
memberBernhard Hiller13-Nov-12 22:20 
QuestionSQL Configuration Pin
DinoRondelly13-Nov-12 4:46
memberDinoRondelly13-Nov-12 4:46 
AnswerRe: SQL Configuration Pin
David Mujica13-Nov-12 5:07
memberDavid Mujica13-Nov-12 5:07 
GeneralRe: SQL Configuration Pin
DinoRondelly13-Nov-12 6:56
memberDinoRondelly13-Nov-12 6:56 
GeneralRe: SQL Configuration Pin
David Mujica13-Nov-12 10:44
memberDavid Mujica13-Nov-12 10: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
Web04 | 2.8.150506.1 | Last Updated 6 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid