OLEDB Connection Questions

Results 1 to 2 of 2

Thread: OLEDB Connection Questions

  1. #1
    Phil Erlewine Guest

    Default OLEDB Connection Questions

    I read the article "OLEDB for ME" and would like to try it.<BR><BR>When I attempt with this code:<BR><BR>&#060;% <BR>Dim Connect, OnMenu %&#062;<BR><BR>&#060;%<BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR>connect .ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51" %&#062;<BR>&#060;% Data Source = C:ajobspathactual_members.mdb %&#062;<BR>&#060;% Initial Catalog=members %&#062;<BR>&#060;% User ID=freedom %&#062;<BR>&#060;% Password=todo %&#062;<BR><BR>...I get this error message:<BR><BR>Microsoft VBScript compilation error &#039 800a0400&#039 <BR>Expected statement <BR>/members_change.asp, line 14 <BR>Data Source = C:ajobschamber_commercedatabaseactual_members.mdb< BR>--^<BR><BR>I think that I have duplicated the example in the article. One thing the article states is that you must have ADO 2.0 & &#062; for this to work. How do I determine what ADO I have? I am running this on my computer using Personal Web Server.<BR><BR>I feel like I am making a very fundamental error here (something I have real talent for doing).<BR><BR>Can anybody shed light here?<BR><BR>S&#039cerely,<BR><BR>Phil E.<BR><BR><BR><BR><BR>

  2. #2
    ASP_DRUG_DEALER Guest

    Default RE: OLEDB Connection Questions

    This will tell which ADO you are running. <BR><BR>set tempconn=server.createobject("adodb.connection")<B R>response.write "ado version=&#060;b&#062;" <BR>response.write tempconn.version & "&#060;/b&#062;<BR>"<BR>set tempconn=nothing<BR><BR>Note: this was stolen from activeserverpages.com.<BR>http://www.learnasp.com/learn/versioncheck.asp<BR><BR>DRUG_DEALER<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
  •