odbc

[LAKSHMI IYER]

hi
am tryin to create a dsn, after i choose the driver and try to verify the test connection i get an error statin unable to connect. kindly help me in solvin this.

[cme_prak]

Hi Lakshmi,

Please check the server name(ORA OR ORACLE...) in ur backend. Using the below cmd u can get the server name

SELECT NAME FROM V$DATABASE

Pls get back to us incase of queries.

Thx,
Prakash C

[debasisdas]

You need to pass database name along with username and password to create the DSN.

[LAKSHMI IYER]

hi,
thanks a lot for those suggestions. i was tryin to create the dsn with 10gcl driver and faced the above problem but the problem doesnt occur while using 9icl. am not able to understand why.

[debasisdas]

Please check if the driver is installed properly. Try to reinstall the drivers.

[meherchaitanyanarayan]

hi odbc stands for open database connectivity it is used for connecting thr front end to backend

[LAKSHMI IYER]

hi
all the suggestions given had helped me a lot, thanks once again.....
am from a non IT background and am findin it very difficult to understand the procedures and functions when i have to trace an error or find how values get loaded in to the table. please help me regardin this