sybase connection

[jfackler]

I've contributed in the past but this is my first request for help. I have an office network on which a lab is running a pc that utilizes a sybase server to serve up a database from (I'm guessing) an ADO program that apparently utilizes a write pessimistic cursor (I can't access the database when the program is running). The data in the database would be remarkably useful to other folks on the network. At present they have to walk to that pc to get the data out (lab results on patients in a medical office). I would like to access the data and distribute it via and asp.net solution. I know how to write the interface and dish up the data once I get connected. My questions are can I, or how do I, connect to the data base from my pc (on the same network); can I, or should I use the sybase server on the networked pc on which the data lives ( how do I do this from my pc); what oledbdata server do I use to access the data. I've got the user ID and password authority to access the database, I just can't find any info on how to get this done....or my brain just can't wrap around the solution.

Thanks for any suggestions.

Jon

[jfackler]

Ok,

So far I've had ten hits on this request and no replys. Let me try a different question. Same problem... How do I connect to a sybase sql server running on another pc on my network? If you don't know but have some reference at least point me towards that. Kind of a crossbred topic I suppose, networking and database serving.

[Nerseus]

Can you show us what your connection string looks like right now? If you don't have one, try to use the Server Explorer to create a new database connection. The main things to input are the server name, database, user id, and password. You can then drag the item from server explorer onto a form and it will create a connection for you.

 

I know Sybase used to be SQL Server but I don't know if they're compatable enough to use the SQL Server driver. I'd use the OleDb provider for now.

 

-Nerseus