Networks·41,470 discussions

NT SQL & Transaction on a Novell based W

Locked

We have a mixture of Novell 4.1 and 4.11 servers, all with the latest service packs.

Theses servers are spread out over several offices connected via WAN connections.

The clients use Client32 to connect to their local servers

The network protocols are IPX/SPX

We do NOT have TCP/IP and it is not an option at this time to install TCP

I need to connect a windows NT4 server running SQL7 and transaction server to this Novell environment.

From what I understand, the DCOM agent on the clients talks to the transaction server, this in turn talks to the SQL Database.

Is it possible for transaction server to run in an IPX environment and talk to the clients? I know that SQL can use IPX as well as named pipes

If so how do we go about configuring the NT server to accomplish this?

The solution needs to be server based, I am able, if I install the windows connection client and TCP, to run the database, but as all our clients are all over the USA it is not feasible to gain c

Topic

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

Sorry, but I think you need the Windows client.

Mike

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

All that you need – install ipx/spx on nt server and your client workstation(this is done) and configure sql to use ipx/spx – we have such configuration with oracle 8. It isn’t required any networks client and but you can use your clents(novell also) easily.

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

The second answer is correct – the network transport is effectively transparent to the SQL system – as long as ipx is installed on both ans there is connectivity then it sould all work fine

rgds

g

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

You just need IPX on the NT server.

The best way to install IPX for the NT server is by adding the latest Netware Client.

After that, Configure SQL to run over IPX. That should be simple, and it might even happen automatically, if you remove IP from the NT box as well.

For the record, if you’re in the planning/testing phase, it might be easier to just look at Novell’s SQL server. It’s faster, and you’ll have an easier time fitting it into your environment.

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

I’m seeing the last question I answered here. I hope this goes to the correct place.

Anyways, in addition to the first answer, of using capture, you will also need to make sure all these users have rights to the print queue.

You may also wantto check the login scripts. If Admin has a personal login script that sets the printer up for him (and it sounds that way to me), the easiest solution would be to cut and paste that login script in as a container login script. You’ll be looking for the line

capture l=1 q=queuename

there may be additional switches, but those ones are neccessary.

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

Dear Sir,

I am working so in WAN with NT include MS SQL 7, Sybase, Oracle, and Novell 4.11 in IPX/SPX that all of them is full integrated.

Please install the GSNW service on your NT server and you have pay attention in network ID when you configure the IPX/SPX protocol .

If you give the same Network ID you can not to connect from NT to Novell.

The Id Network number like ” 100100011″

I hope it is help you.

Best Regards. Ron

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

The performance of the system MAY suffer a hit using only IPX vs IP depending on the client access libraries the app vendor included in their program. The main reason being that the client side DCOM is TCP/IP optimized with other protocols essentially crippled by getting thunked into 16 bit code. This performance hit may not be noticeable though on the remote segments coming into the SQL server over the LAN – but will definitely be noticeable on a local connection. Depending on your app vendor, they may even deny support to a MS SQL server app until you’re running TCP/IP. Don’t want to bum your day, but just another MS “you will be assimilated” problem.

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

This might sound trivial but you have to add the clients to the NT domain. You must also add the SQL database to the ODBC. You may use either IPX or named pipes there are pros and cons to which ones you use and also configuration issues. Good Luck.

NT SQL & Transaction on a Novell based W

In reply to NT SQL & Transaction on a Novell based W

[Author]

Replies