Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connecting (very) old software to SQL server

Author  Topic 

GerhadKreuzer
Starting Member

5 Posts

Posted - 2014-09-09 : 05:54:42
Hi,
I have to connect (very) old Software running at 16 bit Win to SQL Server running at Win Server, any Chance and if yes, how.
I have source code, so some changes will be possible if neccessary.

Thanks a lot.

With best regards

Gerhard

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-09 : 07:47:48
This probably depends on what kind of connection you need. Are you thinking of modifying the old application to talk to SQL Server directly? Then, you're probably looking at converting it to a modern .NET application.

What language is the old app written in?
Go to Top of Page

GerhadKreuzer
Starting Member

5 Posts

Posted - 2014-09-09 : 09:28:50
... the conversion is on the way but Needs some time. No a very quick Change is required so I looking for a quick solution. The old app is written in VB3, and there is the possibillity to use ODBC and they also offer Connection to SQL Server in thees old days, but actually MSACCESS is used, but only as a database, nothing of the forms and all that stuff MSAccess Comes with.
So just think about an old 16bit app try to use SQL Server.

Thanks a lot

With best regards

Gerhard
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-09 : 09:54:22
OK -- do you have an IDE or compiler for VB3 you can use? Do you have access to documentation on VB3 and using ODBC connections?
Go to Top of Page

GerhadKreuzer
Starting Member

5 Posts

Posted - 2014-09-09 : 10:22:21
Hi gbritton,
yes, IDE, Compiler and source, no Problem. VB3 documentation is also there. Before I spend endless hours to find out there is no way, maybe somebody can tell me, yes, works or no way.
I can read old MSAccess db from actual VB.net code, but cant't write. Unfortunately, I Need write operations too .. so using MSACCESS doesnt work out. This leads me to the idea, that probably SQL sever is able to connect, cause there were lot more access mechanism available.

Thanks for helping

Gerhard
Go to Top of Page
   

- Advertisement -