R
ryguy7272
Coming from an Excel/Access background; pretty good VBA experience...I
recently installed SQL Server Express 2008 and VWD 2008. I'm trying to use
VWD to connect to SQL server, based on an example in ch.4 in a book called
'Beginning ASP.NET Databases using VB.NET'. As I mentined in the title, a
line with the syntax objConnection.Open() is highlighted green.
InvalidOperationException was handled by user code. I suspect VWD is not
'seeing' SQL Server, but I don't know what to check, or how to make it work.
I thought I was connected (Tools > Add Connection > Data Source is SQL Server
Server, and I can’t load the browser...objConnection.Open() is highlighted
green. Not sure what to do now, but I would certainly appreciate some
help/advice.
Thanks!
Ryan--
recently installed SQL Server Express 2008 and VWD 2008. I'm trying to use
VWD to connect to SQL server, based on an example in ch.4 in a book called
'Beginning ASP.NET Databases using VB.NET'. As I mentined in the title, a
line with the syntax objConnection.Open() is highlighted green.
InvalidOperationException was handled by user code. I suspect VWD is not
'seeing' SQL Server, but I don't know what to check, or how to make it work.
I thought I was connected (Tools > Add Connection > Data Source is SQL Server
I received a 'succeeded' message. However, I think I am NOT connected to SQLthen browsed to the DB file...named Northwind). When I hit test connection
Server, and I can’t load the browser...objConnection.Open() is highlighted
green. Not sure what to do now, but I would certainly appreciate some
help/advice.
Thanks!
Ryan--