Connecting to Access

[NinelG]

I am new to all of this so please bare with me....

I have a website that is hosted by a 3rd party company.
I need to upload all of my scripts and database to their web server.

Their directory structure looks like this:
1. /www/companyname/scripts : I place all my asp scripts here.
2. /www/companyname/data : I place my Access database here.
3. /www/companyname/html : I place my HTML scripts here.

The connection string is located on a script page in the script directory.

The DSN IP address is 64.55.188.5 on port 1433 and let's say my username is test and password is test.

When the database was on my computer I used this connection string:
ConnString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\WebServer\MyDatabase.mdb;"

What should the new connection string be?

Thanks

 

[BakeMan]

Try something like this

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\WebServer\MyDatabase.mdb;"

BAKEMAN

 

[NinelG]

The database is not sitting on my network. It's on another company's web server.

 

[BakeMan]

I understand but I am assuming you are using ASP to connect to the database. The code will run on that server. You still need to provide the path to the database as if it were running on that server. If the code and the database are on the same server you will need to provide a path like:

c:\inetpub\

http://wwwroot\MyDatabase.mdb;

if the are on different servers you will need a path like:

\\ServerName\inetpub\

http://wwwroot\MyDatabase.mdb;

BAKEMAN

 

[NinelG]

They only gave me a DSN IP address.
I don't know the server path or network path.