Okay, First off as if you did not know i have a small amount of knowledge, so you may think this stupid but i need a hand. I am trying to use SQL 7 to hook up to an Oracle server. This is my problem for some reason i am not able to connect through a linked server. Is it possible that i did not install the ODBC correctly. Books online makes reference to doing this and makes in sound like i am supposed to use a program to do this. All i did was drop the dll where it was needed, should i have run a program to do this.:confused:You need to install the Oracle Drivers for ODBC. You should be able to go into ODBC Admin utility and see Oracle under the list of drivers. You should be able to create a DSN connection to Oracle using the ODBC driver. To test the connection you could use ODBCPING. See the Microsoft article.
INF: ODBCPING.EXE to Verify ODBC Connectivity to SQL Server (Q138541) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138541)|||Do you know where I can get this? I tried installing one, but it doesn't show up in OBDC as a driver choice. I've serched on the net and can't find it any where? I'm in the process of creating a datamart.
Thanks for any help.:eek:|||You need to get a download of the latest MDAC
(Microsoft Data Acsess Components) which will give you all the drivers that you require to create a connection to an oracle server.
http://www.microsoft.com/data/download_270RTM.htm
:D
No comments:
Post a Comment