SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to link sql server to windev?


How to link sql server to windev?

Author
Message
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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?
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5455 Visits: 4639
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.
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14818 Visits: 9006
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/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.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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!!!
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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.
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14818 Visits: 9006
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/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.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29385 Visits: 9671
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.
william.dasilva
william.dasilva
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search