Thanks for the reply. Can you send me some examples. I have attempted to create a connection but it gives me an error: table or view does not exist. but when I run the query in toad it works just fine. Is the problem my connection string?
I am connecting to a default database in oralce. Scott/tiger
' VBScript source code
'Create the conneciton string
strConn = "Provider=MSDAORA;Data Source=TEST;UserID=Scott;Password=tiger;"
Set oConn = CreateObject("ADODB.Connection")
oConn.CursorLocation = 2 'Server side cursor
strSQL = "SELECT * FROM DEPT"
Set rs = CreateObject("ADODB.recordset")
rs.CursorType = 3 'Static Cursor
Set rs.ActiveConnection = oConn