Visual Basic 6.0 & Sql Server 2005 Compatibility?

[Craig]

Hi All,

We have a Visual Basic 6.0 application that we need to communciate with Sql
Server 2005. In the past we had to use the
microsoft.visualbasic.compatibility.dll to allow this software to work with
..NET. This application works fine with Sql Server 2003, but not with the new
2005 version. Is there an update compatibility .dll to make this work?

Please help. At this time we cannot convert the VB 6.0 application to be
..NET because we are FDA compliant.

Thanks in advance,

Craig

[M. Posseth]

Huh ??

maybe you could explain the situation more in detail as you do not need
anything at all in .Net to comunicate with SQL server 2005 from VB6

i.o.w.
VB6 can talk directly to sql server 2005

if it is so that you wrote BL in VB.Net 2005 components wich in there turn
comunicate to the SQL 2005 backend well then you might consider your BL dll
to be COM compatible ( so you can access the DLL`S written in VB.Net from
your VB6 proggy through COM )

if you have another situation please explain in more detail what is exactly
the problem.

regards

Michel Posseth [MCP]

"Craig" wrote:

Hi All,

We have a Visual Basic 6.0 application that we need to communciate with Sql
Server 2005. In the past we had to use the
microsoft.visualbasic.compatibility.dll to allow this software to work with
.NET. This application works fine with Sql Server 2003, but not with the new
2005 version. Is there an update compatibility .dll to make this work?

Please help. At this time we cannot convert the VB 6.0 application to be
.NET because we are FDA compliant.

Thanks in advance,

Craig