This looks like your connection to the Oracle database is being refused due to a bad login, or that the connecting user does not have the right permissions for what you're trying to do.

I expect your program is falling over on the objConn.Open strConnect line, which points to your connection string (strConnect) not being correct.

Have a look at the ADODB.Connection <a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdproconnectionstring.asp" target="_blank">ConnectionString Property</a> to see how it should be formatted and to give you some hints on fixing it.

Other things to check:
  • Can you connect to the database using the details (username/password) you have supplied in the connection string?
  • Can you run that Query on the server and get some results?
  • Does the user you are connecting as (sysdba) have permissions on the server to run the query?


HTH,