Sql Anywhere 10.0.1 3750
OS Server 2008
Framework 3.5.

My app is not able to connect to database. I am getting this error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified

congfig file is below.

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<appSettings>

<add key="Company" value="45"/>

<add key="dbConnection" value="Dsn=ServerA;Driver={SQL Anywhere
10};uid=dba;pwd=sql"/>

</appSettings>

</configuration>

Program is reading the app.config key but not able to connect.

TIA

SanJay

Given this is a Driver Manager error, I would assume you
have created a **user** data source but the application
[?OS Server 2008?] is running as a service and can only
see ***SYSTEM*** data sources.

If that is your problem creating the DSN as a SYSTEM
DSN should resolve this.

Otherwise, the DSN is just not there, at least not on the
machine running the application reporting the error.


"SanJay" <aa (AT) a1 (DOT) com> wrote

Nick: I have the DSN as system dsn. That was the first thing I did.

I think the problem is that since OS is 64 bit ( sorry I fail to mention
that) and my c# app (connecting to sql anywhere 10 db) looks for 32bit
drivers. The System DSN is created using 32bit odbc.

What I found out was that I have to change project-type to x86 before
building the app. This will (supposedly) force app to look for 32 bit
drivers instead of 64bit. I have made the change and will try tomorrow.

Thanks for your reply

"Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@> wrote in
message news:4a78bf94$1 (AT) forums-3-dub (DOT) sybase.com...

Try this XML node in your app.config:

<add key="Asa10ConnectionString"
value="eng=ServerName;dbn=DatabaseName;links=TCPIP {};
Pooling=false;uid=dba;pwd=sql" />
ServerName = Name of Database Service (not computer name !)
DatabseName =Name of Database under ServerName

and then catch key Asa10ConnectionString in your code