I have the following code which works fine when running from a machine other than the sb.sample.edu machine:
If I run it on the sb.sample.edu machine it gives me an error:
Code: Select all
Dim cnnIsland As New SQLBaseConnection( _ "DataSource=sb.sample.edu;" & _ "Transport=npipe;" & _ "ServerName=Test1;" & _ "Database=Island;" & _ "User=*") cnnIsland.Open MessageBox.Show("Connected!") cnnIsland.Close
Gupta.SQLBase.Data.SQLBaseException: Could not create a connection to named pipe at:
\\sb.sample.edu\pipe\SQLBASE\SERVER\Test1. Check that your connection string is valid and server is running.
If I change the data source to localhost it works on the sb.sample.edu machine; but of course is useless on any other machine. It seems that it should work with the sb.sample.edu data source no matter what machine it is being run on.