Microsoft OLE DB Provider for ODBC Drivers error &

Results 1 to 2 of 2

Thread: Microsoft OLE DB Provider for ODBC Drivers error &

  1. #1
    Join Date
    Dec 1969
    Posts
    189

    Default Microsoft OLE DB Provider for ODBC Drivers error &

    Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>i am getting this error when i am trying to connect to a database.i am working on a IIS server. I went through some msdn help but could not understand. <BR>

  2. #2
    Jason Buck Guest

    Default RE: Microsoft OLE DB Provider for ODBC Drivers err

    Trying making your connection like this:<BR><BR>&#039This is your connection string<BR>strConnect7 = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:database e1.mdb"<BR><BR>dim objconn7, objrec7, mysql7, strStatus7, Mytest7, strLength7<BR>set objconn7 = server.createobject("ADODB.Connection")<BR><BR>mys ql6 = "SELECT CLIENT.climat, CLIENT.clinam, CLIENT.state FROM CLIENT;"<BR><BR>mysql7 = "INSERT INTO CLIENT (climat, cliname, state, husb_dob, wife_dob, resp_atty, corp_fiduc, atty_fiduc, huasset, wiasset, coasset, memo, origdate, moddate, modtime, modwho, office) values (&#039" & strclimat & "&#039,&#039" & strcliname & "&#039,&#039" & strselstate & "&#039,&#039" & strhdob & "&#039,&#039" & strwdob & "&#039,&#039" & strselrespatty & "&#039,&#039" & strselcorpfid & "&#039,&#039" & strselattyfid & "&#039,&#039" & strselhuasset & "&#039,&#039" & strselwiasset & "&#039,&#039" & strselcoasset & "&#039,&#039" & strmemo & "&#039,&#039" & strorgdate & "&#039,&#039" & strmoddate & "&#039,&#039" & strmodtime & "&#039,&#039" & strmodwho & "&#039,&#039" & stroffloc & "&#039) ;"<BR><BR>objConn7.open strConnect7<BR><BR><BR><BR>set rstemp7 = objConn7.execute(mysql7)<BR><BR><BR>&#039DON&#039T forget to close your connection when you are done.<BR><BR>Please feel free to contact me if you have any other questions?<BR><BR>Respectfully,<BR><BR>Jason<BR>we bmaster@wnj.com<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
  •