ASP.NET problem with databases

[dhyder]

I'm using ASP.NET with C#. GoDaddy is my webhost. I have tried 3 different databases, (that is why I didn't post this problem on one of the specific database forums) MySQL, Access, and MS SQL. All of the databases are available in GoDaddy and were set up there.

I am also using OleDb connections.

MySQL:
Here is the connections string I used at first
Provider=MySQLProv; Data Source=p50mysql13.secureserver.net; Initial Catalog=***; User Id=***; Password='***';

That did not work though because I did not have the MySQLProv provider on my local machine (which I take to mean on my PC that I am working on). I installed it multiple times from mutiple sources but none of them worked. So instead of that provider I decided to try MS Jet.

When using Jet I get this error instead:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I looked into this error and the most info I could find was that the wrong value might be trying to be inserted into the database. I checked over this and am positive that is not the problem.

MS Access:
Connection String is
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\\hosting\\***\\access_db\\; User ID=***; Password='***';"

Now I am getting this error:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

The research I did on this tells me that I need a .mdw file to set the correct permissions. I was pointed to being able to use the one given as part of Acces (System.mdw), but it doesn't work and I get the same error.

MS SQL:
Now this seemed to have the proper connection string and everything. My problem is with the first query it encounters.
SELECT * FROM product
Error is:
Invalid object name 'product'

Unfortunately I have never used MS SQL before so I am not exactly sure what the problem is with this.

I am at a stuck point for all three of these cases and how no idea which way to turn. What would be my best bet?

Thanks for any help.
Daniel Hyder

[dotneto]

I'm using ASP.NET with C#. GoDaddy is my webhost. I have tried 3 different databases, (that is why I didn't post this problem on one of the specific database forums) MySQL, Access, and MS SQL. All of the databases are available in GoDaddy and were set up there.

I am also using OleDb connections.

MySQL:
Here is the connections string I used at first
Provider=MySQLProv; Data Source=p50mysql13.secureserver.net; Initial Catalog=***; User Id=***; Password='***';

That did not work though because I did not have the MySQLProv provider on my local machine (which I take to mean on my PC that I am working on). I installed it multiple times from mutiple sources but none of them worked. So instead of that provider I decided to try MS Jet.

When using Jet I get this error instead:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I looked into this error and the most info I could find was that the wrong value might be trying to be inserted into the database. I checked over this and am positive that is not the problem.

MS Access:
Connection String is
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\\hosting\\***\\access_db\\; User ID=***; Password='***';"

Now I am getting this error:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

The research I did on this tells me that I need a .mdw file to set the correct permissions. I was pointed to being able to use the one given as part of Acces (System.mdw), but it doesn't work and I get the same error.

MS SQL:
Now this seemed to have the proper connection string and everything. My problem is with the first query it encounters.
SELECT * FROM product
Error is:
Invalid object name 'product'

Unfortunately I have never used MS SQL before so I am not exactly sure what the problem is with this.

I am at a stuck point for all three of these cases and how no idea which way to turn. What would be my best bet?

Thanks for any help.
Daniel Hyder

Invalid object name 'product' means you misstyped the name of the table. Says, "there is no table here with that name('product' )".