Need a DSN to CreateObject??

Results 1 to 2 of 2

Thread: Need a DSN to CreateObject??

  1. #1
    Join Date
    Dec 1969

    Default Need a DSN to CreateObject??

    This line in my code is bombing:<BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR><BR>Wit h this error:<BR>"Data Source Name not found and no default driver specified"<BR><BR>I don&#039t get it. The next line defines Connect.ConnectionString = mystring; however it&#039s bombing just when I try to define the object. Any ideas??

  2. #2
    Join Date
    Dec 1969

    Default RE: Need a DSN to CreateObject??

    I&#039d bet that it really is bombing on the connection string line and that the line number being reported to you is off by one or two. Line numbers being off a bit happens to me all the time, usually because the ASP engine misinterprets a line break above the point of error.<BR><BR>Put in a couple of Response.Write lines to help you be sure of where the error is coming from. Really is worth the time and trouble.<BR><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