Continuing On
Now, we have our connection string/DSN and our passwords all done. Click on Ok, and we're into the ASP!
Your standard ASP connection stuff is there but it looks kinda like this:
Dim objConn Dim connStr Set objConn = Server.CreateObject("ADODB.Connection") connStr = "File Name=K:\da\conn.udl; " objConn.Open(connStr) |
Your done; you can see that I used 'File Name' instead of that other mumbo jumbo. Remember to put your UDL outside of your www pub folder, so people can't download it.