August 23, 2010 at 2:54 pm
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?
August 23, 2010 at 4:52 pm
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.August 24, 2010 at 4:16 am
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.
August 24, 2010 at 5:02 am
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!!!
August 24, 2010 at 5:03 am
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.
August 24, 2010 at 5:05 am
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.
August 24, 2010 at 5:30 am
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.
August 24, 2010 at 8:15 am
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?
August 24, 2010 at 8:17 am
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.
October 25, 2012 at 3:13 pm
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