Connecting MS Access via ODBC

[stigejg]

Hello,

I am going to work on some programs that is connected to an SQL server via ODBC, an i am using this connectionstring:

"PROVIDER=MSDASQL;DSN=kvalreg;UID=sgu;Password=admin;"

But since I dont wont to destroy any data on this server I have decided to make a working copy on an Access-database and have definen my Driver to reach this data. But The connectionstring doesn't work. I figure that I have an wrong "PROVIDER" I have tryed this: "PROVIDER=ODBCJT32"

So are there someone out there who can give me a hint of which provider I have to use?

Best regards Stig

 

[ss27]

You have tried
Provider=Microsoft.Jet.OLEDB.4.0
I have used this provider for MS Access database
tell me if this works with MS Access database.

Goodluck

 

[zemp]

Also make sure that your DSN is a valid system DSN that points to your Access data. If you are using a DSN than all you really need is.

.connectionstring = "DSN=myODBC"

Where 'myODBC' is a valid DSN connection to the database. Within the DSN connection you will specify the provider and any security information. Thanks and Good Luck!

zemp