Avatar of Nitin Shah
Nitin ShahFlag for India asked on

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
Visual Basic ClassicMicrosoft SQL Server 2008Windows Server 2008

Avatar of undefined
Last Comment
EvilPostIt

8/22/2022 - Mon
EvilPostIt

What version of MDAC are you running?
ASKER
Nitin Shah

dear EvilPostt


MDAC 2.6  i think so. How can i came to know what version i am using:
ASKER CERTIFIED SOLUTION
EvilPostIt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Guy Hengel [angelIII / a3]

listening
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
Nitin Shah

dear EvilPostIt:

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

Nitin Shah
EvilPostIt

No probs.
ASKER
Nitin Shah

dear EvilPostt

it is working fine for first time. after re-booting system it gives same error
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
EvilPostIt

Sorry do you mean its stopped working again?
ASKER
Nitin Shah

yes
EvilPostIt

Oh, hmmm. How about installing the SQL Server 2008 Native Client and then using SQLNCLI provider?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
Nitin Shah

it is working fine in 32 bit machine but not in 64 bit machine
EvilPostIt

How about this?
EvilPostIt

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.