473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 4103
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Erwin S. Andreasen | last post by:
I have a Python application server that manages several different data sets, permits various reports to be run on them and the data to be downloaded as tab-delimetered files, all via a web...
1
by: SkunkDave | last post by:
Is there a script anyone has that will automate the addition of an access database to the OBDC datasources in control panel. Thanks
5
by: lastusernameleft | last post by:
For an application displaying read only data targeting a small audience it would seem to me that using ODBC DSNs to delegate user authentication would be quicker to develop than recreating that...
4
by: Andreas Lauffer | last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany
1
by: Randall Perry | last post by:
I've got an app written with Access XP that was deployed 2 years ago using a PostgreSQL backend database through an internet connection. Recently a client upgraded to XP Service Pack 2. After the...
1
by: Harmony407 | last post by:
Hello: Our organization uses MS Access to store all of our members information. Our primary database computer is running on Windows 98. This is where the main database exists. The MS Access...
2
by: SpoonfulofTactic | last post by:
I am building a Blog for my own person use, and I would like to be able to use unicode characters outside the range of the ascii set. However, when I use odbc to access table data, Access returns...
1
by: technocraze | last post by:
Hi guys, I am having trouble resolving this error. Below mentioned is my code and implmentation. MS Acess is my front end and sql server is my backend. What i want to achieve is to be...
6
by: jags_32 | last post by:
We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.