#1  
Old 27th August 2012, 11:28 PM
Markus Hundt
 
Posts: n/a
Default Cannot establish server connection

Hello,

cannot guess what's my mistake:

DotNETProvider 124, NexusDB Server 3.10.04 running as service, Windows 7
64Bit, Visual Studio Shell 2010 (Delphi Prism),

- ADOServerConnectorV3.dll resides in 'bin'-directory of Nexus Server
- 'ADO/.NET Connector' is active in NexusDB V3 Administration
- 'isSecure'-option at server is set

Connection Settings in Visual Studio Server-Explorer
- Server name ist nexusdb@127.0.0.1
- Database is Nortwind
- Port is 16080 (same as ADO/.NET Connector Settings)
- native transport: false
- embedded server: false
- User name: test
- Password: test

Message from Studio: (translated from german) 'The index was out of
range. It must not be negative and smaller than the list. Parameter
name: startIndex'
(Original Message: "Der Index lag au├čerhalb des Bereichs. Er muss nicht
negativ und kleiner als die Auflistung sein. Parametername: startIndex")

Next Try with 'native Transport' and Port 16010 (matching configuration
of Server's TCP/IPv4 Transport)

Message from Studio: NexusDB:<unnamed TnxSession instance>: Unknown user
name or password. [$2734/10036]

Of course user 'test' with password 'test' exists in Users, has
sufficent rights and settings and works with EM without problems.

Any advice would be welcome

TIA
Markus

  #2  
Old 31st August 2012, 01:52 AM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

Any suggestions, anybody?

Markus
  #3  
Old 5th September 2012, 06:53 PM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

No reactions at all? After more than a week?
Somewhat disappointing...


Markus
  #4  
Old 12th September 2012, 12:18 AM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

Somehow it seems to me users of adoprovider are damned to soliloquise...

For the interested (if any):

My own testing and trying suggests until now, that the NexusDB ADO/.NET Connector 124 can only connect with the native transport to a non-secure server (flag "isSecure" not set).

That means for me, that this product is close to unusable in its present condition, while support at the same time is near to not present.

Greetings
Markus
  #5  
Old 12th September 2012, 05:26 AM
Ramzi H.
 
Posts: n/a
Default Re: Cannot establish server connection

Markus, I'm not sure if this will help, but I have been using the trial
version of the ADO.NET adapter for about a week now in VS2010, with C# +
ASP.NET, and it's working fine, mostly.

The Nexus server version is 3.10.04, and running as service in Windows 7
64Bit as well.

Here is what I have in a typical generic data access function, tested
with 'Is-secure' enabled and disabled in the server, and it works fine:

DbProviderFactory factory =
DbProviderFactories.GetFactory("NexusDB.ADOProvide r");
DbConnection myConnection = factory.CreateConnection();
myConnection.ConnectionString =
"Server=nexusdb@192.168.0.2;Database=TESTDB;Port=1 6080;Native=False;Embedded=False;UserName=TestUser ;PassWord=TestPass";

DbCommand myCommand = factory.CreateCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "SELECT * FROM TestTable WHERE EntryID = 1";

myConnection.Open();

using (DbDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.Read())
{
// use the returned data
}
myReader.Close();
}

myConnection.Close();



Hope that helps.

RH

  #6  
Old 13th September 2012, 03:46 AM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

Ramzi, thank you for your advice.

Sadly i got the same error at the moment, myConnection.Open() was executed.

But thanks anyway

Markus
  #7  
Old 13th September 2012, 04:16 AM
tempit tempit is offline
Junior Member
 
Join Date: Oct 2011
Posts: 21
Default

I should have searched the Bugtracker earlier, instead of reading the documentation (sic) and wasting time trying (sic):

Obviously i ran into #1339, #1340 et al.

Markus


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
No connection to server Lee Mc Cauley nexusdb.public.support 2 1st April 2011 01:48 PM
3.08: No connection to server Arnd Iffland nexusdb.public.support 4 31st March 2011 08:05 PM
Releasing a server connection Geoff nexusdb.public.support 2 1st August 2008 08:11 PM
if TCI/IP connection is lost, How to re-establish ? Tyrone Nason nexusdb.public.support 4 15th September 2005 12:10 AM
Reconnecting when server connection is lost Lee Mc Cauley nexusdb.public.support 2 30th April 2005 12:18 AM


All times are GMT +11. The time now is 07:44 PM.


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