Hi all,
My customer is trying to get my VB.net program to access SQL Server 2000 over a Novell network and they're getting a connection error. The SQL Server is on a Windows server, Netware is 6.5, the client is 4.9 and they are using ip, though some parts of the network is still ipx.
The program works for my other customers that use Windows networks. It also works if the program is run from the machine that the SQL Server is on.
The customer can access the database from the 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;
Is there something different I need to do for 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.
Thanks,
Tim