Re: must i use tns?

Try this to go with ODBC and Oracle

Provider=MSDASQL.1;Password=xxx;User ID=Test;Data Source=ODBCName;Persist Security Info=True;

but you have to create an ODBC with the ODBC Administrator first (Found in the Oracle Menuelist "Oracle for NT")

....but I would take the OLE DB Provider for Oracle !!!

"mike" <skyxx_at_263.net> wrote in message news:8pa6vt$31n$1_at_news.cz.js.cn...
> hi all:
> i use vb to develop oracle 's client.i use ole db for oracle,when i use
 ado
> to connect oracle,it always had to create a service on my workstation,can
 i
> not create a service to connect the oracles's database?
>
> i tried use oracle odbc like below:
> cn.Open "Driver={Oracle ODBC Driver};Server=test;User
> ID=test;Password=tset;"
> it always reports:invalid password/userid ,but the userid and password
> surely exist.
>
> how can i do?
>
>
> thanx
>
>
Received on Tue Sep 12 2000 - 16:05:48 CDT