Pervasive
Sign in | Join | Help
in

Connecting to Pervasive via DTO

Last post 06-30-2008 5:38 PM by Mirtheil. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-27-2008 4:51 PM

    Connecting to Pervasive via DTO

    I am testing some a Pervasive-provided C# that uses DTO to connect to a Pervasive DB server and get a list of DBNs. I am able to connect to a database on the Pervasive DB using Pervasive .NET OLEDB driver with no problem. When I try to connect via DTO, I get a 'server not found' errror. I am using the same IP address for both the driver connect string and server name in connect method.

    Is there a setting on the Pervasive Database server that must be configured in order to accept these DTO calls? Is there a way to debug this issue?

  • 06-27-2008 5:22 PM In reply to

    Re: Connecting to Pervasive via DTO

     What version of PSQL is on the client and server?  What's the exact error being returned by the Connect method?

     

    Mirtheil
    I do not answer question via email. Please post questions in the forum.
  • 06-30-2008 2:08 PM In reply to

    Re: Connecting to Pervasive via DTO

    THe server is a Pervasive SQL Server for Windows NT v8.70. The client says it is Pervasive SQL 9.51.

    The result value returned from the Connect command was Dto_errSERVER_NOT_FOUND.

    Here is the sample code we are using:


    DtoSession mDtoSession = new DTOLib.DtoSession();
    dtoResult result;
    try {
    result = mDtoSession.Connect(Properties.Settings.Default.ComputerName, Properties.Settings.Default.UserName,
    Properties.Settings.Default.Password);
    if (result != 0)
    {
    Console.WriteLine("Error connecting to server. Error code:" + result.ToString());
    Console.ReadLine();
        }

    The computer name value in this sample was set to an IPAddress

  • 06-30-2008 5:38 PM In reply to

    Re: Connecting to Pervasive via DTO

     Using the code you posted, I changed the connect to point to my machine.  It worked.  Since you are using V8.7 on the server and v9.5 on the client, you might be having problems there.  I would recommend either downgrading the client to v8.7 or upgrading the server to 9.5. 

     

    Mirtheil
    I do not answer question via email. Please post questions in the forum.
Page 1 of 1 (4 items)
© 2008 Pervasive Software Inc. All Rights Reserved.