Page 1 of 1

VB3 and SQL Server

Posted: Tue 19 Dec 2017 10:57
by aaronpawlak
Hello,

I am completely new to all of this and looking around for help.Does anyone know if it is possible for an application written in VB3 to work with SQL Server?I have an VB3 application which utilizes DAO to read and write to and from an Access 2 database, and it uses bound controls...
I am being asked if I can replace the Access 2 database with an SQL Server database and modify the VB3 application so that it now reads and writes to and from the SQL Server database!!Does anyone know if this is even possible? Or recommended ? .I went through many resources and also SQL tool explainer videos but did not find any solution for this issues. Please help me out.

Any help will be appreciated.
Thank you.

Re: VB3 and SQL Server

Posted: Thu 21 Dec 2017 10:54
by Shalex
Please consider using ODBC Driver for SQL Server in your project.