trouble with odbc connection

hello to all readers!

i know my english is terrible, but i hope someone can decrypt this posting and is able to help me.

since is switched from mysql to oracle database i could't get a odbc connection to my database. under mysql the following vbs worked very well:

strComplete="DRIVER=MySQL ODBC 3.51
Driver;SERVER=localhost;UID=batch;PWD=*****;DATABASE=cta;"

Set objConn = CreateObject("ADODB.Connection")

    objConn.open Connect_String(cta), scott, wasx21

    Set rs = objConn.execute ("select * from test;")

Record = rs.Fields(0).Value

    objConn.Close
Set objConn = Nothing
msgbox("Done!")

under oracle i tryed (after a huge hours surfing)

strComplete="Driver={Microsoft ODBC for Oracle};" & _


            "Server=localhost.cta;" & _

            "Uid=Scott;" & _

            "Pwd=******"


Set objConn = CreateObject("ADODB.Connection")
    objConn.open Connect_String(cta), scott, wasx21

    Set rs = objConn.execute ("select * from test;")

Record = rs.Fields(0).Value

    objConn.Close
Set objConn = Nothing
msgbox("Done!")

but it did'nt work.

please help me!

thx
tom hofer Received on Fri Apr 02 2004 - 11:12:34 CST