dbHudson
06-01-2003, 01:11 PM
I am trying to connect to an MS SQL 2000 DB that has user login info for my site.
My COM component DLL file is stored on the webserver-under c:\winnt\system32. I am trying to hardcode the DLL COM file with this DSN and server name of the DB server that is called within my login.asp for ADO connectionstring. The login.asp file creates an object for this COM so it can verify if the user is found in my DB or not.
So the webserver needs to connect to the DB server via dsn name?
I know that the webserver also needs a DSN setup for System DSNs to go my sql.blabla.com and then the DBNAME for the DSN. Also, does any one know if I need to setup a DLL to engage this DSN under the SYSTEM DSN on the webserver ?
Any comments or suggestions are appreciated. Thanks.
My COM component DLL file is stored on the webserver-under c:\winnt\system32. I am trying to hardcode the DLL COM file with this DSN and server name of the DB server that is called within my login.asp for ADO connectionstring. The login.asp file creates an object for this COM so it can verify if the user is found in my DB or not.
So the webserver needs to connect to the DB server via dsn name?
I know that the webserver also needs a DSN setup for System DSNs to go my sql.blabla.com and then the DBNAME for the DSN. Also, does any one know if I need to setup a DLL to engage this DSN under the SYSTEM DSN on the webserver ?
Any comments or suggestions are appreciated. Thanks.