By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,718 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,718 IT Pros & Developers. It's quick & easy.

ODBC data acess and asp.Net applications.

P: n/a
Hi,

I have a problem when accesing data with and ODBC provider under asp.Net applications.

The question is that if I run the application in the same server where data is stored then data is displayed normaly, but if the ODBC catalog file is in other computer in local netwok (with his Domain Server SBS 2003) I receive next error:

ERROR [S0002] [Liant][Relativity][CRDM]File not found. ERROR [IM006] [Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr del controlador ERROR [01000] [Microsoft][Administrador de controladores ODBC] El controlador no admite una versión de ODBC distinta de la que la necesita la aplicación (vea SQLSetEnvAttr).

Are some solution to it? Where I can find information about it?

thank you!!!
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ODBC is about the worst (read "slowest") possible way to connect to a
database. It is a wrapper for OLE DB, for which there are Managed classes in
the CLR to work with. Most databases (you didn't mention which one) have OLE
DB drivers. However, you can also use ODBC if you like. Just use a DSN-Less
Connection. A DSN is a resource where information about the connection to a
database is stored. It sounds like you're using a File DSN. Instead, you can
put all of your Connection information into the Connection String, thus
avoiding the problem of locating the DSN.

For more on Connection Strings, see http://www.connectionstrings.com.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Jordi" <Jo***@discussions.microsoft.com> wrote in message
news:40**********************************@microsof t.com...
Hi,

I have a problem when accesing data with and ODBC provider under asp.Net applications.
The question is that if I run the application in the same server where data is stored then data is displayed normaly, but if the ODBC catalog file
is in other computer in local netwok (with his Domain Server SBS 2003) I
receive next error:
ERROR [S0002] [Liant][Relativity][CRDM]File not found. ERROR [IM006] [Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr
del controlador ERROR [01000] [Microsoft][Administrador de controladores
ODBC] El controlador no admite una versión de ODBC distinta de la que la
necesita la aplicación (vea SQLSetEnvAttr).
Are some solution to it? Where I can find information about it?

thank you!!!

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.