Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to link sql server to windev? Expand / Collapse
Author
Message
Posted Monday, August 23, 2010 2:54 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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?
Post #973740
Posted Monday, August 23, 2010 4:52 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #973780
Posted Tuesday, August 24, 2010 4:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 7,027, Visits: 6,198
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 Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #973984
Posted Tuesday, August 24, 2010 5:02 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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!!!
Post #974010
Posted Tuesday, August 24, 2010 5:03 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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.
Post #974011
Posted Tuesday, August 24, 2010 5:05 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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.
Post #974013
Posted Tuesday, August 24, 2010 5:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 7,027, Visits: 6,198
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 Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #974030
Posted Tuesday, August 24, 2010 8:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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 . No I don't speel check .



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?
Post #974143
Posted Tuesday, August 24, 2010 8:17 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
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 . No I don't speel check .



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.
Post #974146
Posted Thursday, October 25, 2012 3:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 9:33 AM
Points: 1, Visits: 3
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
Post #1377307
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse