vb6 with sql 2008 & win 2008


I am using vb6 application with sql 2000 & sql 2005 database operating under win xp, win 2000 and win 2003. The application works fine and has no error in operating

But recently I have installed Win 2008 64 bit and Sql 2008 64 bit . But the said vb6 application is giving error.

i am attaching error message and my coding.
vb6appwin2008err1.doc
Nitin ShahAsked:
Who is Participating?
 
EvilPostItConnect With a Mentor Commented:
2.6 does not work with SQL Server 2008. Update to the latest mdac version and this should work. Although you way want to be careful as the Microsoft Oracle Provider will no longer work.
0
 
EvilPostItCommented:
What version of MDAC are you running?
0
 
Nitin ShahAuthor Commented:
dear EvilPostt


MDAC 2.6  i think so. How can i came to know what version i am using:
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
listening
0
 
Nitin ShahAuthor Commented:
dear EvilPostIt:

after loading MDAC 2.8 version, it is working fine. thanks for your kind help

Nitin Shah
0
 
EvilPostItCommented:
No probs.
0
 
Nitin ShahAuthor Commented:
dear EvilPostt

it is working fine for first time. after re-booting system it gives same error
0
 
EvilPostItCommented:
Sorry do you mean its stopped working again?
0
 
Nitin ShahAuthor Commented:
yes
0
 
EvilPostItCommented:
Oh, hmmm. How about installing the SQL Server 2008 Native Client and then using SQLNCLI provider?
0
 
Nitin ShahAuthor Commented:
it is working fine in 32 bit machine but not in 64 bit machine
0
 
EvilPostItCommented:
How about this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.