Hi guys, this is my first time here and im a little lost - so i'm hoping this is the right area to post this (I have used other forums before, but jumping in and out of various msdn area's makes figruing out a site map very differcult at first).
Anyway, i've got Visual Basic 2008 Express edition and im working through the Absolute Begineers Guide to VB. I'm currentally at database's (lessons 8 and 9 so far) and unfortuantly the video is using VB 05 and sql server 05, all i have is sql compact 3.5. While i can do most of what they ask, i cannot do it with the easy they can (in particular i do not have as many options, and i cannot create a diagram).
BTW Im currentally using the add -> new item -> "Local Database".
Now there is a different item i can add called "Service-Based Database" which requires SQL server 05 - sounds like the one they are using in the vids.
So in keeping in my 'special' way of doing things i decided to download the 08 version of SQL server and not suprisingly it doesn't work by magic.
So basically, how do I get my VB IDE to be able to intergrate the SQL 08 features like it apparentally can with 05.
If this is really obvious, or has been answered before (I have tried searching - but don't really know what to search) at least it will be easy for you to solve.
Thanks.
EDIT: Its getting worse, now when i try to (using the compact 3.5) try to get a DataGridView or Details view of my table from the datasources onto my form, it crashes in debug (ie while running)
"System.DllNotFoundException was unhandled
Message="Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
Source="System.Data.SqlServerCe"
TypeName=""
StackTrace:
at System.Data.SqlServerCe.NativeMethods.SafeRelease(IntPtr& ppUnknown)
at System.Data.SqlServerCe.SqlCeCommand.ReleaseNativeInterfaces()
at System.Data.SqlServerCe.SqlCeCommand.Finalize()
InnerException:
"
Home > Visual Basic IDE > How to get SQL server 08 to work with Visual basic 08.