Database format not recognize when using data
hello guys! I need ur advices.... here's the problem i encountered. I use MS ACCESS as my database and the data for the connection. when i set the properties, it displays a message that says, database format not recognize. I'm using VB 6.0 and MS ACCESS 2000. Is there any other way that I can connet to the database and 1 more. How can I populate the listview with my data from the database, coz i can get it. Thank You! I really appreciate it!
Re: Database format not recognize when using data
are you using a dsn or dsnless connection ? ideally you want to use a dsnless connection., but dsn's are easier
Re: Database format not recognize when using data
What are your references to the Project?
Are you using DAO 3.6 or ADO 2.7 or above?
Earlier references will give you your symptoms
Re: Database format not recognize when using data
actually ADO but i realized that I still don't know the ins and outs of the ADO.
Re: Database format not recognize when using data
Most likely, you are using the wrong (older) provider.
To connect to an Access 2000 database, you will need to use Jet 4, not Jet 3.5.
The complete provider string is "Microsoft.Jet.4.0"
Depending on how you open your connection, you will need to change the Provider property of the connection object, or you will need to alter the provider option in the connectionstring.
Re: Database format not recognize when using data
hate to correct a moderator and all;),but the provider is Microsoft.Jet.OLEDB.4.0
here is an example connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\MadrEIs\madreis.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=True;Jet OLEDB:Database Password=this is the access database passsword
note that for access databases that have a password, you DO NOT use password=BLAH in the provider strng, you should use... jet oledb:database password=BLAH as shown above. if your database doesnt have a password, you can omit this section, which would give you a conn string of just:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\MadrEIs\madreis.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=True
Re: Database format not recognize when using data
Quote:
Originally Posted by cjard
hate to correct a moderator and all;),but the provider is Microsoft.Jet.OLEDB.4.0
You got me there :p
I was just checking to see if anyone would notice... honest :p
Re: Database format not recognize when using data
Sorry, but I'm using VB 6.0, with SP6, and Access 2002, and it still does not recognize my db format.
Jet 4.0 execution is automatic with SP6, isn't it?.
May the Office XP Home, SPANISH version, be having problems?.
Thanks. Guillermo.
Re: Database format not recognize when using data
and will you please show the string...what is the provider for ms excel 97 as well as excel 2000.. for ADO as well as RDO...
tx in advance