chinasyndrome
Programmer
- May 14, 2008
- 12
Hi
I am trying to use Dot net to connect to a sybase DB.
this connection string usually works but i have run into a snag
I use this connection string
ODBC; Driver=Sybase SQL Anywhere 5.0;Dbf=<path to db>;Uid=<LOGIN>;Pwd=<Password>;Dsn=<DSN NAME>
this server has 2 databases called MGN.db
1 is in c:\data\
the other is in c:\data\satelite
there is 1 dsn setup called MGN
when i set my string using the path to c:\data\satelite
i still get the data to the first
i tried creating a second dsn strickly to the second DB
called MGN2 but that is not working
when the sybase server starts up but DB are attached and active
when the practice loads their app it asks which db they want to use.
I need a connection string that can get me to the data in
c:\data\satelite\MGN.db
any help will be appreciated
I am trying to use Dot net to connect to a sybase DB.
this connection string usually works but i have run into a snag
I use this connection string
ODBC; Driver=Sybase SQL Anywhere 5.0;Dbf=<path to db>;Uid=<LOGIN>;Pwd=<Password>;Dsn=<DSN NAME>
this server has 2 databases called MGN.db
1 is in c:\data\
the other is in c:\data\satelite
there is 1 dsn setup called MGN
when i set my string using the path to c:\data\satelite
i still get the data to the first
i tried creating a second dsn strickly to the second DB
called MGN2 but that is not working
when the sybase server starts up but DB are attached and active
when the practice loads their app it asks which db they want to use.
I need a connection string that can get me to the data in
c:\data\satelite\MGN.db
any help will be appreciated