SQL 7.0--Please Help

Results 1 to 4 of 4

Thread: SQL 7.0--Please Help

  1. #1
    Shelz Guest

    Default SQL 7.0--Please Help

    If the SQL Database is on the same server as my WebSERVER all is fine when I use this code....<BR>strConnect="Provider=SQLOLEDB;Persist Security Info=false; " & _<BR> "User ID=sa;Initial Catalog=CSR;" & _<BR> "Initial File Name=D:MSSQL7DataCSR.mdf"<BR><BR>But when have to access a remote SQL DB after I&#039;ve moved the application it can&#039;t find the DB.<BR><BR>strConnect="DRIVER={SQL Server};" & _ <BR> "SERVER=RNSQL;DATABASE=csr;" & _ <BR> "UID=sa;PWD=;"

  2. #2

    Default RE: SQL 7.0--Please Help

    you need to specify the IPaddress or hostname of the remote server in your connection string - Dont use Initial File Name - point to the server where the SQL DB resides

  3. #3
    Shelz Guest

    Default RE: SQL 7.0--Please Help

    So don&#039;t use this code...?<BR><BR>strConnect="DRIVER={SQL Server};" & _ <BR> "SERVER=RNSQL;DATABASE=csr;" & _ <BR> "UID=sa;PWD=;" <BR>

  4. #4

    Default RE: SQL 7.0--Please Help

    Check this out for pointers...<BR><BR>http://www.4guysfromrolla.com/webtech/070699-1.shtml

Posting Permissions

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