#1  
Old 1st February 2018, 10:20 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default ODBC conecting to NX1 files

I have been able to get the ODBC Connection to see the files however I now get the following error.

According to the system monitor it is locked by the nxserver.exe

Connection to server was not successful!NexusDB: <unnamed TnxDatabase instance>: INTERNAL: File could not be opened [...\Pathto\nxTrans.cfg, error 32, The process cannot access the file because it is being used by another process] [$2405/9221]

How can I connect to this Database?
  #2  
Old 3rd February 2018, 11:50 PM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 202
Default

Quote:
Originally Posted by bluephlame View Post
I have been able to get the ODBC Connection to see the files however I now get the following error.

According to the system monitor it is locked by the nxserver.exe

Connection to server was not successful!NexusDB: <unnamed TnxDatabase instance>: INTERNAL: File could not be opened [...\Pathto\nxTrans.cfg, error 32, The process cannot access the file because it is being used by another process] [$2405/9221]

How can I connect to this Database?
NexusDB is not filesharing. You need to set up a connection to the transport the server is using (usually tcp/ip). There should be options for this visible in the ODBC connection?
  #3  
Old 5th February 2018, 08:18 PM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

Hi,

Thanks for your reply, when I try to connect via TCP, on the machine hosting the database. with the server name

Nexusdb@127.0.0.1

---------------------------
Error
---------------------------
Connection to server was not successful!

NexusDB: <unnamed TnxWinsockTransport instance>: Cannot locate or connect to network server. [$2C0E/11278]
---------------------------
OK
---------------------------

I have been able to get a Winsock connection working in enterprise manager, but none of these options try and connect. Do I need to allow or enable the service somehow?
  #4  
Old 7th February 2018, 07:14 AM
bluephlame bluephlame is offline
Junior Member
 
Join Date: Jan 2018
Posts: 9
Default

How do I determine what transport the server is running?

When I connect via TCP/IP I get an error message as if the server is not even running.

Through Enterprise Manager, I can connect via Winsock, but there is not an option for that in the ODBC Connector.
  #5  
Old 7th February 2018, 09:21 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: ODBC conecting to NX1 files

> How do I determine what transport the server is running?

Depends on the nxServer version and wether it runs as a service or
directly on the desktop.

> When I connect via TCP/IP I get an error message as if the server is
> not even running.
>
> Through Enterprise Manager, I can connect via Winsock, but there is
> not an option for that in the ODBC Connector.


Winsock and TCP/IP is the same thing. If EM can find the server
automatically and connect, that should also work for the ODBC connector.

Perhaps you could let us know what versions of nxServer and EM you are
running?

--
Eivind Bakkestuen [NDD]


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC conecting to NX1 files bluephlame nexusdb.public.support.odbc 0 1st February 2018 08:49 PM
ODBC V1 and .Net Data Provider for ODBC thenoiseboy nexusdb.public.support.odbc 0 9th January 2013 12:36 AM
Error when conecting Micael nexusdb.public.support.php 19 25th April 2012 12:34 AM
ODBC driver V3.09 with nexusdb 1.3 files Tony Peppercorn nexusdb.public.support.odbc 0 5th January 2012 05:00 PM
Delphi 2007 on Vista cannot create dcu files in program files folder John Jefkins nexusdb.public.support 9 7th June 2007 07:45 AM


All times are GMT +11. The time now is 05:42 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.