Re: connecting to oracle with odbc

Try something like this:

Set Conn = New Connection
Conn.CursorLocation = adUseClient
Conn.Open ("PROVIDER=MSDAORA.1;data source=mydata;" & _ "user id=scott;password=tiger;Persist Security Info=True") Set Rs = New Recordset
Rs.Open "Select * from your_table", Conn

Hope this will help.

moris oz wrote in message <3a059597$3_at_news.barak.net.il>...
>
>From: "moris oz" <moriso_at_noks.com>
>Subject: connecting to obdc !!!!
>Date: Sunday, November 05, 2000 7:10 PM
>
>i'm trying connecting to oracle thrue odbc thrue asp format :
>
><%
>set conn = server.createobject("adodb.connection")
>conn.open "DSN=MYDATA;UID=myname;PWD=Sercret"
>
>%>
>
>but i get :
>
>Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC Driver Manager] Data source name not found and no default
>driver specified
>
>I'm using standart oracle driver for ODBC
>
>i tried all kind of format string from the web :
>http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#ODBCDriverForOra
 c
>le
>
>but without any success........
>
>SO, WHats i'm doing wrong.....
>Any help will be apriciated......
>
>thanks allot
>
>moris oz
>
>
>
>
>
>
Received on Sun Nov 12 2000 - 19:33:27 CET