Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2 db same name on 1 server, cant get right data

Status
Not open for further replies.

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
 
here is what happens on startup

"D:\Program Files\Easy\Shared Files\dbsrv7.exe" -ti0 -xTCPIP -tl0 -nEASY "D:\Program Files\Easy\Data\MDM.db" -nDSERV "D:\Program Files\Easy\Data\Data2\MDM.db" -ndentserv2 "D:\Program Files\EASY\Data\ast_easy.db" -nast_serv
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top