Remote SQL Connection

Results 1 to 2 of 2

Thread: Remote SQL Connection

  1. #1
    Mark Guest

    Default Remote SQL Connection

    Can anyone give a quick guide to connecting to a remote SQL server or point me in the direction of a page?<BR><BR>Thanks,<BR><BR>Mark

  2. #2
    Join Date
    Dec 1969

    Default RE: Remote SQL Connection

    Enter the data for the server into a string. Then use said string to connect to the data source<BR><BR>Example:<BR><BR>Let&#039s say you want to connect to database Duck using the sa account with password quack on server DonaldDuck with IP Address<BR><BR>Here&#039s the code:<BR><BR>DuckDB = "Provider=SQLOLEDB.1;password=quack;Persist Security Info=True;User ID=sa;Initial Calatalog=Duck;Data Source="<BR><BR>That&#039s it!<BR><BR>Here&#039s how to open a recordset to the Duck database<BR><BR>dim rs<BR>set rs = server.createobject("ADODB.recordset")<BR>SQL = "select * from some_table"<BR> SQL, DuckDB<BR>...<BR><BR><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