Connecting to a bd

Results 1 to 2 of 2

Thread: Connecting to a bd

  1. #1
    Join Date
    Dec 1969

    Default Connecting to a bd

    I am having trouble connecting to my database...<BR>This is what I have:<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en "c:/Mssql7/Data/liz_Data.MDF"<BR><BR>That jis the right path, but it won&#039t open! This is the error:<BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>Does anyone know what I am doing wrong??<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Connecting to a bd

    You need something along these lines...<BR><BR>Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;Password=;User ID=sa;Initial Catalog=liz_Data;Data Source=(local)"<BR>Conn.Open<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