VB+ODBC problem - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Guest replied

25 February 2003, 13:29
Re: VB + ODBC

I recall there being an issue with DAO3.6 and Oracle databases regarding case sensitivity of the table name you are selecting from.

Try changing it to upper case and have another go.

Good Luck
Leave a comment:
Guest started a topic VB+ODBC problem

24 February 2003, 15:08
VB+ODBC problem

Hello all,

I'm having a problem connecting to an Oracle table using DAO and a
DSN.

The connection works ok.

But I keep getting the error "3184 - Could not execute query - could
not find the linked table." - when I try to open a recordset.

However, using the Oracle ODBC 32 bit tester, I can run the query
against the DSN that the recordset uses without a problem, rows are
returned as normal.

The code I'm using at the moment is simple, as folows.

Set ws = DBEngine.Workspaces(0)

strConnection = "ODBC;DSN=AIRE_CAP1;UID=********;PWD=******"

Set db = ws.OpenDatabase("", False, False, strConnection)

Set thisRec = db.OpenRecordset("select * from system_avail;")

Does anyone know why this is? It used to work before.
Tags: None

Working...

X