Results 1 to 4 of 4

Thread: ADOBD Connection

  1. #1

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

    Question

    Hi y'all

    I'm using vb script to connect to an oracle database. I have my scripts on an IIS box which connects to another server (running NT Server). The Win2000 IIS box runs oracle client andthe NT server is running Oracle server and this is where the database is .I am however getting an error message from my scripts when I try to run them. The connection I've set up between the two servers is ODBC ( Microsoft for oracle) and the ODBC test suggest the connection is cool and the gang.
    The error states that the vbscript:

    "Can't create ADODB.Connection"

    My connection object and string are here:

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

    Can anyone tell me what I'm doing wrong? I'm really stuck and the liberal kicking I gave each server didn't do the trick either.

    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
    Mar 1999
    Posts
    93
    Hi!
    According to error message it seems that you are falling on CreateObject command. Maybe MDAC is not properly installed?
    Regards,
    Vit

  3. #3
    Addicted Member
    Join Date
    Sep 1999
    Location
    Philippines
    Posts
    196
    Be sure to make a reference to the adodb libary first.

    also, it helps to make and test connections using the dataenvironment before you do to the hard code.

  4. #4
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    Your using the wrong provider...

    try MSDAORA

    BTW- no need to use both a DSN *AND* a provider as long as the DSN is set up on the server and the TSN names are as well.

    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    monte96_@hotmail.com
    monte96@vbgarage.com


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..

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