ACCESS to SQL SERVER conversion help

Results 1 to 2 of 2

Thread: ACCESS to SQL SERVER conversion help

  1. #1
    Join Date
    Dec 1969

    Default ACCESS to SQL SERVER conversion help

    Could someone please help me convert the connection code below so it will work for a SQL server sitting on another server (called "zeus" as I just cant work it out)<BR><BR>Many thanks in advance!<BR><BR><BR>Set DataConnection = Server.CreateObject("ADODB.Connection")<BR>DataCon nection.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _<BR> "DBQ=" & Server.MapPath("dbpostcard.mdb")<BR>Set cmdDC = Server.CreateObject("ADODB.Command")<BR>cmdDC.Acti veConnection = DataConnection<BR>cmdDC.CommandText = SQL<BR>Set RecordSet = Server.CreateObject("ADODB.Recordset")<BR>RecordSe t.Open cmdDC, , 0, 1

  2. #2
    Join Date
    Dec 1969

    Default RE: ACCESS to SQL SERVER conversion help

    You&#039;ll find a fair amount of help regarding connection strings to sql server if you just run a search ....<BR>application("db") = "Provider=SQLOLEDB; DATA PROVIDER=SQLOLEDB;SERVER=server;DATABASE=database; UID=username;PWD=password;"<BR><BR>should get you started.<BR><BR>There is also a lot of stuff on about upsizing from access to sql server, run a search.<BR><BR>Also, as you are now using proper :-) database, why are you passing SQL to it? Look into stored procedures asap.

Posting Permissions

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