Hi,
I know that it is not possible to connect in ide(vb2005 express) to a remote sqlserver. The 1 million dollar is ... can i connect to a sql2000 server that is installed on the same pc as vb2005 express I know I can do it through code but I would like to try this in the ide.
Cheers,
Frank

connect in ide to sql2000
Gentleman Auditor
Hi,
I know that it is not possible to connect in ide(vb2005 express) to a remote sqlserver. The 1 million dollar is ... can i connect to a sql2000 server that is installed on the same pc as vb2005 express I know I can do it through code but I would like to try this in the ide.
Cheers,
Frank
buddingb
Omnicoder
Info
Sure you can connect to any SQL Server database directly in code from VB Express. Its only the IDE tools that VB Express supports Access/SQL Express only.
The compiler is the same for Express as any version of the VB 2005. And all you would have to do is provide a suitable connection string and all the data controls will work just fine.
But from the VB Express IDE, Access and SQL Express Only
Deepak Kumar Sharma
No, it only works with SQL Server 2005 Express.