Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

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
0
Nitin Shah
Asked:
Nitin Shah
  • 7
  • 5
1 Solution
 
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
 
EvilPostItCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now