General discussion

Locked

NT SQL & Transaction on a Novell based W

By Gareth Eyers ·
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

This conversation is currently closed to new comments.

16 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

NT SQL & Transaction on a Novell based W

by msullivan In reply to NT SQL & Transaction on a ...

Sorry, but I think you need the Windows client.

Mike

Collapse -

NT SQL & Transaction on a Novell based W

by Gareth Eyers In reply to NT SQL & Transaction on a ...
Collapse -

NT SQL & Transaction on a Novell based W

by dtomko In reply to NT SQL & Transaction on a ...

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.

Collapse -

NT SQL & Transaction on a Novell based W

by Gareth Eyers In reply to NT SQL & Transaction on a ...
Collapse -

NT SQL & Transaction on a Novell based W

by Gary Sharp In reply to NT SQL & Transaction on a ...

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

Collapse -

NT SQL & Transaction on a Novell based W

by Gareth Eyers In reply to NT SQL & Transaction on a ...
Collapse -

NT SQL & Transaction on a Novell based W

by Kevin Anderson In reply to NT SQL & Transaction on a ...

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.

Collapse -

NT SQL & Transaction on a Novell based W

by Gareth Eyers In reply to NT SQL & Transaction on a ...
Collapse -

NT SQL & Transaction on a Novell based W

by Kevin Anderson In reply to NT SQL & Transaction on a ...

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.

Collapse -

NT SQL & Transaction on a Novell based W

by Gareth Eyers In reply to NT SQL & Transaction on a ...
Back to Networks Forum
16 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums