MS SQL Server, connecting from asp just using system dsn name

connecting from asp just using system dsn name

Author	Message
Bob Pfeif #1 / 2	connecting from asp just using system dsn name Have you considered using a Microsoft Data Link instead of an ODBC DSN? You can create a .udl file to reference by right clicking in WindowsNT Explorer or on the desktop and selecting New/Microsoft Data Link. You then set up the connection using the OLE DB Provider for SQL Server, server name, authentication info, database, etc. The reference in the ASP would look something like: set oConn = Server.CReateObject("ADODB.Connection") oConn.Open "File Name=<path>\datalinkfile.udl" set CreateConnection = oConn
Wed, 07 Aug 2002 03:00:00 GMT

Stuart Bowe #2 / 2	connecting from asp just using system dsn name UDL's are no use, if you drag the udl onto notepad, you can see the password and user name. odbc's should be able to hold the user name and password but at the moment ours aren't. Quote: > Have you considered using a Microsoft Data Link instead of an ODBC DSN? You > can create a .udl file to reference by right clicking in WindowsNT Explorer > or on the desktop and selecting New/Microsoft Data Link. You then set up > the connection using the OLE DB Provider for SQL Server, server name, > authentication info, database, etc. The reference in the ASP would look > something like: > set oConn = Server.CReateObject("ADODB.Connection") > oConn.Open "File Name=<path>\datalinkfile.udl" > set CreateConnection = oConn
Sat, 10 Aug 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]