DSN configuration

Results 1 to 2 of 2

Thread: DSN configuration

  1. #1
    Salman Majid Guest

    Default DSN configuration

    hi...i uploaded my asp app. and database, but how will i configure DSN on the server, cause when i view my site, nothing is picked from the database...

  2. #2
    Bart Beekhuizen Guest

    Default RE: DSN configuration

    On your webserver (I&#039ll take IIS for example) go to Administrative Tools --&#062; Data Sources (ODBC) and click the tab &#039System DSN&#039. Make up a name for your link en select the DB.<BR>Now go to your ASP app. You&#039ll have to connect to the datasource. You do it now like this:<BR><BR>Set objConn = Server.CreateObject ("ADODB.Connection")<BR>objConn.Open "DSN=&#060;YOUR_DATA_NAME&#062;"<BR><BR>If it won&#039t work because you have no access to Webserver, try use this:<BR>dim strConnect<BR>Set objConn = Server.CreateObject ("ADODB.Connection")<BR>strConnect = "DRIVER={Microsoft Access Driver _(*.mdb)};DBQ=f:inetpubwwwrootfpdb&#060;YOUR DB.MDB&#062;"<BR>objConn.Open "DSN=Live"<BR><BR><BR>Hope it help. Else contact your ISP.<BR><BR>Regards,<BR><BR>Bart Beekhuizen<BR>bartb@sq.nl.com<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts