DSN question

Results 1 to 3 of 3

Thread: DSN question

  1. #1
    Scott Moore Guest

    Default DSN question

    I was attaching to our SQL server db fine, but now we&#039ve added multiple dbs on the same machine. How do I specify the correct SQL server in the connection string. Is it the Provider variable? I keep getting an error message while attaching to the db. My old connection string was this:<BR><BR>Session("objConn").ConnectionString = "DSN=ccp01db;uid=sa"<BR><BR>Now the new database is called celullar7, I need to add this to the connection string, so it finds the database. Any help?

  2. #2
    Join Date
    Dec 1969

    Default RE: DSN question

    You&#039ll need to specify the path to the new databse when you establish a NEW DSN for that database. In your SQL code, you&#039ll reference the table name.

  3. #3
    Geoff Yaworski Guest

    Default RE: DSN question

    The Application("&#060;ConnectionString&#062;") variable in global.asa contains all the information you need to connect the db.

Posting Permissions

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