Connection Manager is not running at the specified port number.

[toddffr]

I am having an intermittent problem connecting via ODBC to a PSQL 2000i SP4 server on a Win2K Server with a client of either Win2k, XP pro or Win2k Server (web). I get the following error:

[Pervasive][ODBC Client Interface][Client LNA]The ODBC Client Interface cannot access the data source because SQL Connection Manager is not running at the specified port number. Contact your system administrator for assistance.

This happens for a few hours then all is ok again.

The first time it happened was the day after an 8 hour power outage and the UPS didn't make it for that time. Maybe this was coincidental?

We have apps that are written in Delphi using Titan and they have no problems connecting to the DB. It would appear that it is an ODBC issue. I thought that it was a DNS or name resolution problem, but an NSlookup on the connecting machine resolved the name fine. With the Pervasive ODBC driver I have read before that if an ip address is used and not a name it can cause a similar error. A name has been used.

I am perplexed at what could be causing it now.

Any suggestions and help are gratefully appreciated.

 

[toddffr]

I had been receiving this error on occasion and other issues with the driver for our website.

I found that if I put an entry in the services file on the server with PSQL 2000i

\system32\drivers\etc
w3sqlmgr 1583/tcp

this solved my problem and actually speed up my connection significantly.

Apparently this allocates the port to the relational service.

Todd

 

[ticron]

Hi.

I receive the same error every time. We changed the IP address on the file server and now I cannot open a database I absolutely must have. I called Pervasive and they told me to take a hike.

"[Pervasive][ODBC Client Interface][Client LNA]The ODBC Client Interface cannot access the data source because SQL Connection Manager is not running at the specified port number. Contact your system administrator for assistance."

Todd, I tried your suggestion. I find a services file in F:/ETC but I'm not sure where to put the w3sqlmgr 1583/tcp line.


# Host specific functions

Under this ?

I tried doing that and it didn't solve the problem

 

[jayconverse]

Do you have more than 1 NIC? Set Multihomed to Yes.

Jay Converse
IT Director
Systemlink, Inc.

 

[ticron]

Hi.

My problem has been solved. Pervasive engine wasn't running on the server. I fixed it by going to the server console and typing MGRSTART[/b]

More here

http://support.novell.com/cgi-bin/search/searchtid.cgi?/10071382.htm

Take care everyone ^_^

 

[ticron]

Oops sorry the server command is MGRSTART

 

[jayconverse]

That's a Netware command. This thread was about a Win2K server...

Jay Converse
IT Director
Systemlink, Inc.

 

[ticron]

The thread header is "Connection Manager is not running at the specified port number" trust me anyone getting that error message is going to read this thread.

So if you are getting that error message, and you're running a Netware server, it maybe be b/c Pervasive engine has not been started. Solve the issue by typing MGRSTART at the server console. sry if this helps anyone.