dsn-less connection and DRW (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


Luis -> dsn-less connection and DRW (2/28/2001 21:31:00)

There's a free server ( www.DOMAINDLX.com ), which allows uploading via FTP.
The instructions are as follows:
"The 'database' and 'scripts' subdirectories have write/read permissions. Therefore, you have to upload your database to the 'database' subdirectory and upload your scripts that require write permissions to your 'scripts' subdirectory."

They also say that I must create a "DSN-LESS" connection with this code:
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver
(*.mdb);DBQ=" &
Server.MapPath("/USERNAME/database/yourdatabase.mdb")

Global asa is not supported.

My question is: Where should I paste this code? (where exactly)

------------------
Luis Miguel Gonzalez
Buenos Aires, Argentina
luismg@gmx.net





Stuey -> RE: dsn-less connection and DRW (3/1/2001 20:03:00)

Spooky is probably your best bet for this.

However you need to create an ASP Page and put it where ever you need to create a database connection and close it when you have finished

Stuart(Also on a steep learning curve)

------------------
Stuart Steele
StuWeb Productions 07808254916
http://www.stuweb.co.uk





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875