The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Connecting to Oracle from A SQL Instance
Posted: 09 Mar 07 2:38 PM
|
fiogf49gjkf0d Hi All,
I'm trying to run a stored procedure from oracle. I've done this before calling a sql stored procedure but can't seem to setup my connection string properly, or possibly missing some software, i installed the oracel client tools, and setup an alias but still can't get the script to use the Microsoft ODBC Driver for Oracle. My error says it's trying to use ODBC SQL Server Driver.
I have a connection string of
objConn.Open Application("DRIVER={Microsoft ODBC for Oracle};CONNECTSTRING=*aliasname*;uid=user;pwd=password;")
then I try to run objConn.Execute ''exec STORED_PROCEDURE"
Any help will be grately appreciated |
|
|
|
Re: Connecting to Oracle from A SQL Instance
Posted: 23 May 07 3:03 PM
|
fiogf49gjkf0d Taking a look at connectionstrings.com it looks like your connectionstring is ok, but why is it in Application()?
objConn.Open "DRIVER={Microsoft ODBC for Oracle};CONNECTSTRING=*aliasname*;uid=user;pwd=password;"
should connect just fine. (I removed the Application call - it should expect a variable name). |
|
|
| |
|
Re: Connecting to Oracle from A SQL Instance
Posted: 28 May 07 10:29 AM
|
That's where I checked... The source "Taking a look at connectionstrings.com "
I love that site. It was recently sold and I was concerned it would go away, but instead they just revamped it..
I never try and remember the connectionstring now - why remember when you can just look it up? |
|
|
| |
|