ODBC pervasive software odbc interface for windows

Last post 01-29-2010 1:53 AM by gregvg. 14 replies.
Page 1 of 1 (15 items)
Sort Posts: Previous Next
  • 01-20-2010 4:01 AM

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    ODBC pervasive software odbc interface for windows

    Hello, I am trying to open een DDF file in Visual Studio. Our ERP program is using PSQL9. We have to installe the client version to use our ERP. On the internet I found a way to open DDF file with ODBC. http://www.stonefieldquery.com/OnlineHelp/SageAccpacERP/_0x30pue4l.htm I have to create en new data source, but when i want to make a new one, I receive another window This one: http://www.stonefieldquery.com/OnlineHelp/SageAccpacERP/_0x30pul6a.htm In this window I have to select the server. But I want to select the DDF file, so I can access the BTR files. Can anyone help me to find the "pervasive software odbc interface for windows" driver, so I can make a new DSN connection by selecting a DDF file. tnx !!!
  • 01-20-2010 7:56 AM In reply to

    Re: ODBC pervasive software odbc interface for windows

    The page that you found has information on using Pervasive.SQL 7 -- this is MUCH older than the PSQLv9 that you are using.  Try going here:

        http://www.goldstarsoftware.com/press.asp

    And open the white paper "Creating an ODBC Data Source", or check the online help screens that come with PSQLv9 for more information.

  • 01-20-2010 8:00 AM In reply to

    Re: ODBC pervasive software odbc interface for windows

    What happens if you try the following:

    Client DSN:

    Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)

    Click on the System DSN Tab

    Click Add

    Scroll down and select Pervasive ODBC Client Interface

    Enter a Data Source Name (Your Choice), Address (Server Name)

    Click Get DSN List

    Server DSN:

    Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)

    Click on the System DSN Tab

    Click Add

    Scroll down and select Pervasive ODBC Engine Interface

    Enter a Data Source Name (Your Choice)

    Click Create

    Enter a Database Name (Your Choice)

    In Dictionary Location Browse to where the DDFs are located

    If the data files are in a different location, click add and browse to where they are

  • 01-20-2010 8:01 AM In reply to

    Re: ODBC pervasive software odbc interface for windows

    Or use the information provided by Goldstar :)

  • 01-20-2010 8:02 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    Dear, Thant's for your feedback!!! Do you know where i can download the Pervasive ODBC Engine Interface driver? tnx!!
  • 01-20-2010 8:07 AM In reply to

    Re: ODBC pervasive software odbc interface for windows

    It installs automatically as part of the PSQL client.

     

  • 01-20-2010 8:10 AM In reply to

    Re: ODBC pervasive software odbc interface for windows

    The Pervasive Engine Interface is only available with Pervasive Server or Workgroup Engine.  Pervasive Client only has the Client Interface.  You need an engine in order to access the data. 

    For example:

    Computer A is the file server.  It has the PSQL Engine installed on it and a Server DSN.

    Computer B is the Client.  It has PSQL Client installed and a Client DSN.  The Client DSN talks to the Server DSN.

  • 01-20-2010 8:17 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    I have Pervasive ODBC Client Interface, SQL Native Client and SQL Server. The engine interface is missing i think. (I just installed the software again.)
  • 01-20-2010 8:20 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    I am installing the Server 64bit.
  • 01-20-2010 8:30 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    Now i have the Engine, I am going to try Thank for all the support
  • 01-20-2010 8:34 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    Party time, Its working !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! tnx guys
  • 01-20-2010 12:32 PM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    It's clearly not for me this project. I can connect with the DDF file with Visual 2008. But everytime I want to start the program (just open a datagrid to visualise a table), I receive next program-stop and Visual Studio crashes. """""""""""" Vshost..exe has topped Working Next error Problem signature: Problem Event Name: APPCRASH Application Name: VoorNa.vshost.exe Application Version: 9.0.21022.8 Application Timestamp: 47316898 Fault Module Name: KERNELBASE.dll Fault Module Version: 6.1.7600.16385 Fault Module Timestamp: 4a5bdfe0 Exception Code: c000041d Exception Offset: 000000000000aa7d OS Version: 6.1.7600.2.0.0.256.1 Locale ID: 2067 Additional Information 1: 6e8b Additional Information 2: 6e8bb3c4a26091b02b9c5b7ec99c6605 Additional Information 3: 1ed4 Additional Information 4: 1ed4f21075ad77baae6e18862286eeda Read our privacy statement online: http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 If the online privacy statement is not available, please read our privacy statement offline: C:\Windows\system32\en-US\erofflps.txt """
  • 01-20-2010 1:24 PM In reply to

    Re: ODBC pervasive software odbc interface for windows

     Make sure your program is not set to use "AnyCPU" but is set for "x86" for the CPU type.  PSQL doesn't have a 64 bit driver and it's possible the application is compiling down to 64 bit .NET and is looking for a 64 bit driver and crashes because it can't find one.

     

  • 01-21-2010 9:10 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    You are my hero, tnx!!!
  • 01-29-2010 1:53 AM In reply to

    • gregvg
    • Not Ranked
    • Joined on 01-19-2010
    • Posts 2

    Re: ODBC pervasive software odbc interface for windows

    I am bak, I have still one question. My program is working perfect. I am connectiong to a local path (hard disk). Now I want to expand my program. I would like to connect to a nework path (server). The ODBC interface does not like my idee. I always receive "the directory is invalid (error 35). I have tried to make a networkmapping, but it's not the answer. how can i connect to a network path? tnx
Page 1 of 1 (15 items)