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