connecting from asp just using system dsn name 
Author Message
 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
 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
 
 [ 2 post ] 

 Relevant Pages 

1. Problems using system dsn with asp

2. system dsn not displaying dsn names

3. Adding SQL System DSN Changes Other DSN's from TCP\IP to Named Pipes

4. How do i connect to System DSN using java code

5. User / System DSN fails to connect Oracle Database using Microsoft ODBC for Oracle

6. DSN-less ASP/ADO connect to Sql2K

7. New DSN's can't be connected to from ASP

8. Problem: SQL Server 7 using ASP - Using wildcards with Field Names

9. ASP Connectivity to an Access Database without using DSN's

10. Connecting to SQL Server from VB6 (System DSN only)

11. System DSN: LocalServer - after installation SQL Server 2000 - can not connect to the (local) server

12. ODBC DSN Name Bug (DSN with a trailing space) - Windows 2000


 
Powered by phpBB® Forum Software