Accessing a Access 2003 Database Problem 1

[dalec]

I'm using a aspx page to access an access 2003 database, it worked fine with a 97/2000 database, but, now I get an error "Cant find installable ISAM", I've searched around and cant find any help except short of trying to install access 2003 on the web server (which I really didnt want to do) the server has the latest jet drivers, just a problem with this. My web.config file is fine, and is formatted correctly, just won't open that newer database. I was wondering if there is a way to use a DSN connection with web.config???

Any help is appreciated, btw, the server is 2003/IIS 6

thanks in advance.
Dale

 

[dalec]

One thing I thought of that might help in getting a response, the new database has a password that the other one didnt have. It might be possible that I'm putting the password in the wrong place, here's a sample of my web.config file. Thanks in advance again!!!

<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_database" value="default_oledb.htm" />
<add key="MM_CONNECTION_STRING_database" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\websites\data\database.mdb; uid=admin;pwd=password;" />
<add key="MM_CONNECTION_DATABASETYPE_database" value="OleDb" />
<add key="MM_CONNECTION_SCHEMA_database" value="" />
<add key="MM_CONNECTION_CATALOG_database" value="" />
</appSettings>
</configuration>

 

[dalec]

Well I solved the problem, I ended up using a UDL to connect to the database and since the database is password protected I kept getting "workgroup file not found" error, turns out the syntax for entering the password is:

Jet OLEDBatabase Password=password;

Instead of the usual: pwd= or password=

Since I never got a response I wish I could give myself a star, but incase anyone else has a similar problem this was my solution and I hope it will help someone else.

 

[ca8msm]

Since I never got a response

Please bear in mind that you only gave 14 hours on a weekend for someone to respond to you and a lot of people don't frequent the site on a weekend. What may have helped you is a quick read of the FAQ's (faq855-5780 in particular) which would have ensured that the connection string was correct.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dalec]

Thank you for your reply, the link provided on the faq's timed-out. Maybe they don't work the weekend either. Don't get me wrong, I find a lot of useful information and support this site. My connection string was correct, but no where in the faq's does it explain the correct format of passing a password. In fact it was a long time finding it on my own.

One thing I like to do, is when I find a solution to a problem is to post what I found out, it helps others since not everyone finishes the solution of a question. Often someone will provide a solution but you'll only sometimes hear if it worked. As far as 14 hours and the weekend, experienced programmers and developers work all the time, and it's not strange for a few all nighters here and there.

cheers,
Dale

 

[ca8msm]

My connection string was correct, but no where in the faq's does it explain the correct format of passing a password.

The FAQ that I provided a link to (once you can get it to work!) will show how the password is stored in the connection string as it actually provides you with the correct string (with the password included if you cicked the "Allow password saving" checkbox) that you can simply copy and paste.

As far as 14 hours and the weekend, experienced programmers and developers work all the time, and it's not strange for a few all nighters here and there.

That's true but if you had posted this ona weekday I'm sure it would have been answered fairly quickly.

Anyway, I'm glad you now have it working and thanks for posting your solution.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dalec]

Thanks for the star!!!