ASP in a LAN environment 2

[auger]

I've made some ASP pages for the web and everything is coming along well. I will be launching some ASP apps on our network at work very soon. I'm wondering about connection strings for ASP and MS Access DBs in a multi server intranet environment. I don't have access to the server settings.

I haven't been able to make a db connection at this point. The server admin has been too busy to assist. I've tested some VB scripts on the server and they run fine. Server is IIS (not sure what version but pretty recent). We request pages from our partition sort of like this:

http://123.456.789.123/OurDepartment/OurFolders/ourpages

I know the server name but am not sure if or how I should include it in my connection string.

I've run 'where am I' scripts from within my db folder and these indicate my connection strings should look something like this:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data_ Source=\MyFolder\db\MyDB.mdb;"

...which does not seem to work.

Do I need to reference the server name somehow? The IP address? Is there a better way to go about connecting to our DBs?

Any and all suggestions welcome. Thanks in advance.

 

[shiggyshag]

Best way I find to connect over a muti domain network is using ODBC connection's.
If the database is on a diffrent server to the IIS then I change the IUSR_Server password to something I know then add a user account called IUSR_sever on the server where the database is and set the permissions.

Hope this helps

 

[codestorm]

If you were using MSSQL Server databases i would use a connection string like

"driver={SQL Server}; server=server1; database=pubs; uid=sa; pwd=blah"

however with Access I'd normally use something like ..

"driver=Microsoft Access Driver (*.mdb); dbq=" & Server.MapPath("databasename.mdb&quot

The above _should_ work if you have shared/mapped the path from the database to the IIS machine. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[auger]

Thanks guys.