I am trying to connect a VB.NET 2003 Oledbdataadapter through the wizard to a SQL Server 2005 Database, but i get an error message during the wizard.
These are my steps:
New Connection, Select provider (Microsoft OLE DB Provider for SQL Server), Select Connection: server name, log on: use windows NT integrated security, select database.
I do all these steps then click "test connection" and it is fine, but when I click "ok" and error message pops up.
"Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access Databases with this version of visual studio."
I have attached print shots of the VB.NET 2003 Wizard and of SQL Server Management studio log on screen.
Can anyone help me?
Thanks in advance.