Can't connect to SQL Server from Novell workstation



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 Windows 2003, Netware is 6.5, and they are using ip, though some parts
of the network is still ipx. The workstation is XP sp2 with the Netware
client 4.9.

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


.



Relevant Pages

  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Pass-through queries fail even after SQL Server reconnected
    ... indicates network connectivity problems. ... ODBC is a pretty old way to connect to SQL Server. ... pass-through queries fail due to intermittent connection failures. ... I can easily restablish a connection for ADO. ...
    (comp.databases.ms-access)
  • RE: ASP .Net connection to Sql Server
    ... Using "dbmssocn" tells it to use the TCP/IP network driver, ... It is connecting via a connection string similiar to: ... > string to our production SQL server and everything runs fine. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: java.sql.SQLException (Error establishing socket)
    ... | Error: No active Connection ... Since you are making connections to a remote SQL Server via the Internet, ... If the network is fine, ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Securemote Problem
    ... If you are not the firewall admin on the remote system, ... > I am having trouble connecting to a customer site using Securemote. ... > I cannot access any network resources on the customer network, ... > internet connection is a LAN connection from the DG824M. ...
    (comp.security.firewalls)

Loading