Database Access Using UDL Files
page 3 of 3
by . .
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 26035/ 37

Using UDL files in code

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.


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-25 7:21:10 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search