How to upload DSN?

Results 1 to 2 of 2

Thread: How to upload DSN?

  1. #1
    Join Date
    Dec 1969

    Default How to upload DSN?

    Hello,<BR> I have created a system DSN for a database file and i need to upload that to a server. how and where do I upload DSN to make it work?<BR><BR>Thank you,<BR>Keerthi

  2. #2
    Sumithra Gopalan Guest

    Default RE: How to upload DSN?

    Hi,<BR><BR>If you are asking how to connect to a web server,<BR> You will need to incorporate your DSN details into your code to help the web server connect to the database. The typical code to connect to an MS-Access DB is:<BR> dim conn, rs, sqlmt<BR> set conn=Server.CreateObject("ADODB.Connection")<BR> conn.Open "your DSN name"<BR> Set rs=Server.CreateObject("ADODB.Recordset")<BR> sqlmt="SELECT * FROM tablename"<BR> rs.Open sqlmt, conn, 3, 3<BR><BR> Then, when you are done using the database,<BR> rs.close<BR> set rs=nothing<BR> conn.close<BR> set conn=nothing<BR>else<BR> if you are asking how to connect to your database server,<BR> well, you have already set up the connection to it with your DSN creation. So, don&#039t worry.<BR><BR>HTH!<BR><BR>Sumithra <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