Page 2 - What am I doing wrong?

alternatively, you have what is called an"Oracle odbc test" in oracle->network tools.

test if you can connect through DSN you created.

ok I have done as you have done agsuresh here is some screen shots of this test form.
Setting up DSN:


Setting up the ADODC through connection string and using ODBC

The fail

Hope somebody can see how im messing up here

I don't believe the dsn is set up correctly. It doesn't have a server set up. i.e. where does the actual oracle database reside?

ok taking that on boeard i ran the following SQL query through sql*plus
select host_name from v$instance;
and it returned
HOST_NAME
---------------
GER-VYZHXO7I1P5

Entered that into the server space and still the same error as above

Using that host and some other oracle home data for directory start I get this new error

I found the following link that might help you some with this: http://www.topxml.com/conference/wr...dc/text/dov.asp

Also, I would suggest that you contact the oracle help desk to see if you can get more assistance with this.

It seems you are using the Microsoft OLEDB provider for ODBC.
Try again using (1) the Oracle provider for OLEDB OR (2)Microsoft OLEDB provider for ORACLE.
1 should have been installed by Oracle and the second comes from Microsoft.

Also check the 9i documentation. "i" stands for networking , which means you may have to do additional setup of the database such as domains, permissions etc Check the installation if the ODBC drivers were correctly installed. some of these drivers are platform specific ie (win 95/98/me) & (NT/XP/2000/2003) Mostly i-series should be installed on the letter platform.

Suresh

I want to thank you all for your help on this matter, it appears in hinsight that the actual Oracle wasnt right. I uninstalled it all and reinstalled with the help from the following site: http://www.coade.com/cadworx/pid/Oracle9i.htm
It helped through the entire setting up DSN and everything.
Thanks again Onslaught
Hope to be around more
Ger

skip the "driver={};" part, just use "dsn=..."

yup that was it actually here's the code i used if anybody else does need this help in the future