How to link sql server to windev?

  • That's about it, been googling for 1 hour and I found nothing besides the native windev Hyperfile sql which allows us to open the tables.

    Is there any way to get direct access via linked server?

  • Ninja's_RGR'us (8/23/2010)


    That's about it, been googling for 1 hour and I found nothing besides the native windev Hyperfile sql which allows us to open the tables.

    Is there any way to get direct access via linked server?

    If I remember it correctly WinDev is an IDE not a RDBMS therefore not sure how Linked Server appears in the same phrase - Linked Server is a feature designed to connect two RDBMS.

    Programs coded in WinDev do have the ability to interact with SQL Server, I'm pretty sure WinDev supports odbc and ole on top of native connectivity.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • I have never done this, but I'm going to throw this idea out. Have you looked into SOAP?

    ODBCs would definitely do it, but they're messy at the best of times. You'd probably have to go with File ODBCs if you used them.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (8/24/2010)


    I have never done this, but I'm going to throw this idea out. Have you looked into SOAP?

    ODBCs would definitely do it, but they're messy at the best of times. You'd probably have to go with File ODBCs if you used them.

    What is soap and how would I implement it?

    I've done linked servers to file before with dbase, but this one seems to be encrypted or just binary.

    I did a search here fpr windev and only got 7 results so I wasn't getting high hopes for this!

    The idea the link windev to our erp is definitly possible but I would have preffered the reverse!!!

  • PaulB-TheOneAndOnly (8/23/2010)


    Ninja's_RGR'us (8/23/2010)


    That's about it, been googling for 1 hour and I found nothing besides the native windev Hyperfile sql which allows us to open the tables.

    Is there any way to get direct access via linked server?

    If I remember it correctly WinDev is an IDE not a RDBMS therefore not sure how Linked Server appears in the same phrase - Linked Server is a feature designed to connect two RDBMS.

    Programs coded in WinDev do have the ability to interact with SQL Server, I'm pretty sure WinDev supports odbc and ole on top of native connectivity.

    Ya I know windev to sql works, but I need to do the reverse to avoid coding the same app twice.

  • Well here's a response I got from Windev support :

    Hi Remi,

    HyperFileSQL is the database included with WINDEV.

    You can access this database using an ODBC driver.

    This ODBC driver can be provided to you by your supplier for the Carus application.

    Please do not hesitate to contact me for any additional information.

    Best Regards.

    Let's hope that does the trick and that they are willing to spully the driver.

  • Ninja's_RGR'us (8/24/2010)


    Let's hope that does the trick and that they are willing to spully the driver.

    Spully? Is this a new technical term that I haven't heard of? Sounds like one of those new-fangled magic spells to me. @=)

    Ninja's_RGR'us (8/24/2010)


    What is soap and how would I implement it?

    Not quite sure how you'd implement it in SQL 2000 (didn't you say some databases were 2000 in another thread?), but SOAP stands for Simple Object Access Protocol. It's an XML / web-based communications protocol for different computers to pass information back and forth. Here's the "WhatIs" definition.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (8/24/2010)


    Ninja's_RGR'us (8/24/2010)


    Let's hope that does the trick and that they are willing to spully the driver.

    Spully? Is this a new technical term that I haven't heard of? Sounds like one of those new-fangled magic spells to me. @=)

    Ninja's_RGR'us (8/24/2010)


    What is soap and how would I implement it?

    Not quite sure how you'd implement it in SQL 2000 (didn't you say some databases were 2000 in another thread?), but SOAP stands for Simple Object Access Protocol. It's an XML / web-based communications protocol for different computers to pass information back and forth. Here's the "WhatIs" definition.

    For those who didn't figure it out : I meant supply :w00t:. No I don't speel check :hehe:.

    Yes we has to support 2000 and possibly sql 7.

    Thanks for the free google... and does anyone goes a good series of articles I can digest to see if this could be a valid option?

  • Ninja's_RGR'us (8/24/2010)


    Brandie Tarvin (8/24/2010)


    Ninja's_RGR'us (8/24/2010)


    Let's hope that does the trick and that they are willing to spully the driver.

    Spully? Is this a new technical term that I haven't heard of? Sounds like one of those new-fangled magic spells to me. @=)

    Ninja's_RGR'us (8/24/2010)


    What is soap and how would I implement it?

    Not quite sure how you'd implement it in SQL 2000 (didn't you say some databases were 2000 in another thread?), but SOAP stands for Simple Object Access Protocol. It's an XML / web-based communications protocol for different computers to pass information back and forth. Here's the "WhatIs" definition.

    For those who didn't figure it out : I meant supply :w00t:. No I don't speel check :hehe:.

    Yes we has to support 2000 and possibly sql 7.

    Thanks for the free google... and does anyone goes a good series of articles I can digest to see if this could be a valid option?

    Nevermind for the links, I just saw the 10+ articles in the main link.

    Thanks again.

  • Were you ever able to use the HyperFileSQL ODBC driver to create a DSN and a linked server in MS SQL.

    I am also trying to pull information out of WinDev, into MS SQL, from MS SQL.

    Thanks,

    William

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply