469,628 Members | 1,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

ODBC data acess and asp.Net applications.

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
1 3907
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.

Similar topics

1 post views Thread by Erwin S. Andreasen | last post: by
5 posts views Thread by lastusernameleft | last post: by
4 posts views Thread by Andreas Lauffer | last post: by
1 post views Thread by Harmony407 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.