DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Database Connection Problem

Thread Solved

•

Join Date: Oct 2009

Posts: 23

Reputation: Israelsimba is an unknown quantity at this point

Solved Threads: 0

Israelsimba Israelsimba is offline

Offline

Newbie Poster

Database Connection Problem

Oct 16th, 2009

i have created a database for subscriptions in MS Access 2007. I want to link it with my forms using the code below but its saying unrecognised database format.

Dim conn As Connection
Set conn = New Connection
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb".......

Now i have converted it to Access 2000 format and it wont work. I have also converted to acces 2002-2003 but it doesnt work either. i wanted to convert it to Access 97 format but that option is not there on Save As in Access.
Can anyone help because i cant link with the database.
Thank You

•

Join Date: Mar 2009

Posts: 828

Reputation: vb5prgrmr will become famous soon enough

Solved Threads: 150

vb5prgrmr

Offline

Practically a Posting Shark

Oct 16th, 2009

See http://www.connectionstrings.com

Good Luck

If anyone has helped you solve your problem, please mark your thread as solved.

Thanks

•

Join Date: Jul 2008

Posts: 471

Reputation: abu taher is an unknown quantity at this point

Solved Threads: 24

abu taher

Offline

Posting Pro in Training

Oct 17th, 2009

install service pack 6 for vb6.

I like sword. Attack or Defense.

•

Join Date: Jul 2008

Posts: 471

Reputation: abu taher is an unknown quantity at this point

Solved Threads: 24

abu taher

Offline

Posting Pro in Training

Oct 22nd, 2009

have you any problem more? if not please solve it.

I like sword. Attack or Defense.

•

Join Date: Jul 2009

Posts: 13

Reputation: PoisonedHeart is an unknown quantity at this point

Solved Threads: 0

PoisonedHeart PoisonedHeart is offline

Offline

Newbie Poster

Oct 22nd, 2009

Try to change your Provider ,., try to use Microsoft Jet 4.0,.I think it's the latest version..,if there are available service packs on their site...,download it and install it on your machine...My MS Access version is 2003, and my programs works smoothly in both 3.51 and 4.0....

[...Just trying to help...]

•

Join Date: Oct 2009

Posts: 2

Reputation: VINOD_2553 is an unknown quantity at this point

Solved Threads: 0

VINOD_2553 VINOD_2553 is offline

Offline

Newbie Poster

34 Days Ago

If u import ur database in msaccsess them u meight this problum
to solve this problem fllow the fllowing steps
1.open ur project
2. Create a new data base
3. Close ur project
4. Open the data base
5. Now import ur table
6. Now u can found ur error is solved

•

Join Date: Jan 2008

Posts: 248

Reputation: AndreRet is an unknown quantity at this point

Solved Threads: 35

AndreRet

Offline

Posting Whiz in Training

31 Days Ago

Your connection string is faulty. You need to declare the connection first.

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb"
'Ensure that you have referenced MS ActiveX Data Objects Library in Project/Refrences.
'You can also use Jet 4.0 as below
 
conn.Open "PROVIDER= Microsoft.Jet.OLEDB.4.0;persist security info=false;data source = C:\subscriptions2.mdb"
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb"
'Ensure that you have referenced MS ActiveX Data Objects Library in Project/Refrences.
'You can also use Jet 4.0 as below

conn.Open "PROVIDER= Microsoft.Jet.OLEDB.4.0;persist security info=false;data source = C:\subscriptions2.mdb"