VB.NET: Can't connect to MS SQLserver with Novell

[duffaz]

I am trying to access an MS SQL Server over a Novell network using a VB.net program and I can't get the connection string to work. It works for my other customers that use Windows networks. It also works if the program is run from the server. The customer can access the database from the same workstation using Access with no problems, it's just my program that won't work.

I changed the connection string from Integrated Security=SSPI to User ID and Password, but it still won't connect. The user has all rights.

Data Source=SQLserver;Initial Catalog=databasename;User ID=username;Password=password;

Anyone know what I need to do differently for Novell.

Thanks,

Tim

[willakawill]

I am trying to access an MS SQL Server over a Novell network using a VB.net program and I can't get the connection string to work. It works for my other customers that use Windows networks. It also works if the program is run from the server. The customer can access the database from the same workstation using Access with no problems, it's just my program that won't work.

I changed the connection string from Integrated Security=SSPI to User ID and Password, but it still won't connect. The user has all rights.

Data Source=SQLserver;Initial Catalog=databasename;User ID=username;Password=password;

Anyone know what I need to do differently for Novell.

Thanks,

Tim

Hi Tim,
Take a look here

[duffaz]

Thanks for the reply.

The SQL Server is on a Windows server, its just the network that is Novell. The program runs if it is copied to the machine the SQL Server is on, but will not connect to the server if it is run from a workstation.

The customer can assess the SQL Server from Access that is on the same workstation. The program also works on a different customer's network which is all Windows.

Is there something different I need to do with Novell in the connection string or in the programming, or is there additional software that needs to be loaded on the workstation for vb.net? They have .Net Framework 1.1 loaded.

Tim