read ODBC Connection

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I just wonder is it possible to read ODBC Conneton from MS Access
application.

My application uses ODBC Connection to SQL server and mdb backend.
If user machine does not setup ODBC Connection then the report fails.
I just wonder that if I can read ODBC Connection then I can let user
know to contact admin to create ODBC Connection.


Your help is great appreciated,
 
Access does not support ODBC connection to an MDB backend... it allows you
to link tables in another MDB, but not via ODBC.

In VBA code, you can access the .Connect property.
 
m:
I just wonder is it possible to read ODBC Conneton from MS Access
application.

My application uses ODBC Connection to SQL server and mdb backend.
If user machine does not setup ODBC Connection then the report
fails. I just wonder that if I can read ODBC Connection then I can
let user know to contact admin to create ODBC Connection.
Click to expand...

It's unclear to me what you mean by "read ODBC Connection".

Do you mean there's a DSN, and you want to check if it's set up?

Or do you mean that you want to check if the server designated in
the ODBC connection is available?
 
It's unclear to me what you mean by "read ODBC Connection".

Do you mean there's a DSN, and you want to check if it's set up?

Or do you mean that you want to check if the server designated in
the ODBC connection is available?
Click to expand...

Thanks for the message,
It is DSN.

Thanks again,
 
Access does not support ODBC connection to an MDB backend... it allows you
to link tables in another MDB, but not via ODBC.

In VBA code, you can access the .Connect property.

 --
 Larry Linson, Microsoft Office Access MVP
 Co-author: "Microsoft Access Small Business Solutions", published by Wiley
 Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Click to expand...

Thanks for the message,
My applicaiton has link to SQL server table which using ODBC
Connection.
I would like to give user message when the link broken or fail or the
ODBC does not exist. If it possible to create link for the users if it
fails to link to backend SQL server table.

Thanks again,
 
:
I just wanted to know does it exist in the computer, if not, just
give user message to contact admin to create or can programming
using VBA create for user if it does not exist.
Click to expand...

You do realize that there is no need for the DSN at all if you have
the appropriate DSN-less connect string, right?
 
Back
Top