Sybase Connection Help

[Lloyd Taylor]

Hello,

I am having problems with connecting to sybase using visual studio.
I have installed Sybase Open Client and now have the drivers to create a
sybase connection.

In visual studio I have successfully created a connection to 1 sybase
database on a server (Server1) using tool --> Connect to Database.
However now everytime I try and connect to additional Sybase Databases on
different servers (i.e. Server2) it just creates a connection to (Server1).
Can anyone help me with this?

Thanks in advance.

Lloyd

 

[William \(Bill\) Vaughn]

Let's see your connection string.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Lloyd Taylor]

I am not using a connection string just yet, I am trying to use a visual
studio wizard.
I am building a web application, and I am just adding data sources to Visual
Studio using the add data connection wizard.
This is so I can add data manually (Create Tables etc)- I am not
programtically manipulating data just yet.

I have defined 3 sybase servers I want to connect to using Sybase Open
Client.
Then using the Visual Studio Data Connection Wizard:

I first click on add data connection.
I then click the Sybase ASE OLE DB Provider as my provider
Then I add my connection details and click OK

I added the 1st data source perfectly, (I can now navigate around the tables
etc.. )
However every time I try and add the other two data sources the wizard just
add's another instance of the 1st data source.

Even if I edit the server name in the last tab - it just ignores my
edits............