Still fighting

Results 1 to 2 of 2

Thread: Still fighting

  1. #1
    Shelz Guest

    Default Still fighting

    I have this code I&#039;m using to connect to a remote database... It gives me an error like this....<BR><BR> Microsoft OLE DB Provider for SQL Server error &#039;80004005&#039; <BR>[DBNMPNTW]Specified SQL server not found. <BR><BR>The code is below:<BR><BR> strConnect="Provider=SQLOLEDB;Data Source=usa24servnetdev;" & _<BR> "Database=CSR;User ID=sa;password="<BR><BR>

  2. #2
    James H. Guest

    Default Double check your spelling, or...

    Either you misspelled it or you can try this one which works for me:<BR><BR>myDSN="DRIVER={SQL Server};" & _ <BR> "SERVER=YOURSERVERNAME;DATABASE=YOURDBNAME;" & _ <BR> "UID=sa;PWD=;" <BR><BR>Replace YOURSERVERNAME and YOURDBNAME with the appropriate names, all else leave as is.

Posting Permissions

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