SQL Express 2005

25 Nov 2005 2:41 PM

Rick

Is it possible to use SQL Express 2005 for an application in Visual Basic 6.0?

Since, the objective is not to installthe whole SQL Express system in the
end-user machine, what should be installed, for the VB 6 Application?

What system requirement should be for the VB 6 user?
Should I install de NET framework?

All the information I see in MSDN is for SQL Express 2005, but nothing
related to VB6.

Thank you.

--
Rick

25 Nov 2005 5:31 PM

Chris2

"Rick" <R***@discussions.microsoft.com> wrote in message
news:5DFD9F7C-EDFE-4FC7-9449-479E925CAD36@microsoft.com...
> Is it possible to use SQL Express 2005 for an application in

Visual Basic 6.0?
Show quote

>
> Since, the objective is not to installthe whole SQL Express system
in the
> end-user machine, what should be installed, for the VB 6
Application?
>
> What system requirement should be for the VB 6 user?
> Should I install de NET framework?
>
> All the information I see in MSDN is for SQL Express 2005, but
nothing
> related to VB6.
>
> Thank you.
>
>
> --
> Rick

Rick,

I've been connecting to SQL Server 2005 Express Beta from Access
2000 via its ODBC driver using both ADO and Linked Tables. I'd
imagine the full release will work for that, and OLEDB as well. If
Access 2000 can do it, I can't see a reason that VB6 couldn't.

As for where SQL Server is, that can be anywhere on the network, as
long as the connection string in your application is built
correctly.

As for installing the .Net Framework, SQL Express needs it, of
course. However, Access 2000 and VB6 don't, I believe, interact
with it at all. ADO.Net will need the .Net Framework, but I'm
running ADO 2.8, and that also doesn't use the .Net Framework.

Sincerely,

Chris O.