read ODBC Connection

[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 Developer]

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.

 

[David W. Fenton]

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.

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?

 

[iccsi]

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?

Thanks for the message,
It is DSN.

Thanks again,

 

[iccsi]

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

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,

 

[David W. Fenton]

:

It is DSN.

What do you want to do with the DSN?

 

[iccsi]

:







What do you want to do with the DSN?

--
David W. Fenton                  http://www.dfenton.com/
contact via website only    http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -

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.

thanks again,

 

[David W. Fenton]

:

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.

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