dns less connection String

[djaccess]

What is the right code for creating a dns connection string to the following address. dnot know the local address

http://www.tribassrecords.co.uk/dba/tribassrecords.mdb

[Smokie]

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("dba/tribassrecords.mdb") & ";"

[D3mon]

Its gonna be one of these:

Code: Select all

'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("tribassrecords.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/tribassrecords.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\tribassrecords.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("tribassrecords.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/tribassrecords.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\tribassrecords.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)

[djaccess]

keep getting back http error code 401 unathorised

[D3mon]

I'm not big on Access, but I'd say you'll need to check the permissions on the .MDB file.

[gwx03]

make sure its on a writable path??? like brinkster has a /db directory for read/write to databases

if it still doesn't work and you've contacted your sys admin you can try this out : http://www.webwizguide.info/asp/tuto...tabase_pt2.asp

[Nick]

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by djaccess

keep getting back http error code 401 unathorised


<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Make sure you have set full read/writ permissions the IUSR account on the database file/directory. You may need to contact your host to get this done.

P.s. when you have a live site, you should make so effort to hide the location of the Access database. Preferably put it in a directory which is below web access (many hosts provide a 'data' directory alongside a 'web' or 'www' directory). If you can't do that, name the directory and database something obscure. You may want to do this before you contact your host to set permissions, otherwise they may have to be re-set.

[gwx03]

i think the easiest way to get things done is just call your sys admin