file dsn

[Guest_imported]

how do i create a file dsn and then where do i put it on the web server. I have a sql database and i am making asp html pages for it.

 

[ufobaby]

hi,
got to
Start > Settings > ControlPanel > Odbc..
and create a file DSN this should be done on the server itself.
OR
u want to create this on the fly i.e during runtime ???


Niraj

 

[Guest_imported]

how do i create it during run time?

 

[ufobaby]

hi,

1.]
firstly u would not require to create it at runtime as it's always a better optoin to do it before hand. but still if need be, u would do it thru vb and create a coomponent or so and use it in ur ASP page. Exampple in VB ->

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q171146

2.] Easier way to do it is refer to the file DSN like ->

Set ConLog = Server.CreateObject("adodb.connection&quot
ConLog.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\user.mdb;pwd=sauser001"
Set rs = ConLog.Execute("select * from table&quot
u will have to check for proper name for SQL server (ummmm i think it's "SQL Server&quot pls check.

Hope this helps.


Niraj