Results 1 to 3 of 3

Thread: Help!

  1. #1

    Thread Starter
    Addicted Member Skeen's Avatar
    Join Date
    Jul 2000
    Location
    Abingdon, Oxon
    Posts
    138

    Unhappy

    Can anyone tell me what this error means in english! I'm trying to connect my asp's to an oracle database and its all going belly up!

    Microsoft OLE DB Provider for ODBC drivers error '80004005'

    [Microsoft][ODBC driver manager]Data source name not found and no default driver specified.


    The error message occurs on this bit of code:

    Set cnAcqAcc = CreateObject ( "ADODB.Connection" )
    cnAcqAcc.ConnectionString = "Provider=MSDASQL;DSN=CustServ;UID=CustServ_owner;PWD=CustServ_owner;"

    cnAcqAcc.open

    I think its my provider in my connection string, but can anyone tell me what I'm doing wrong

    Cheers n beers

    Skeen
    "It wasn't the booze that made me snooze, It was the Gin that did me in!"

  2. #2
    Lively Member
    Join Date
    Oct 2000
    Location
    Leicestershire; ENGLAND
    Posts
    71
    Have you created the DSN on your machine (through ODBC Manager) ?

  3. #3

    Thread Starter
    Addicted Member Skeen's Avatar
    Join Date
    Jul 2000
    Location
    Abingdon, Oxon
    Posts
    138

    Yep

    I'm going through an IIS Server and I reckon thats where the problem is.
    "It wasn't the booze that made me snooze, It was the Gin that did me in!"

Posting Permissions

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



Click Here to Expand Forum to Full Width