First of all, there are two ways to work with databases with SQL Server and. Here is the code that works beautifully because it is on a local drive: If anyone can SHOW me the code to connect, I'd would love, love love to see it. So, in short, the price you pay for the free version of VB 2010 Studio Express and SQL 2008 Express is that you cannot connect remotely through SSMSE AND you cannot connect in code.īelieve me, I've tried exhaustively messing with TCP/IP settings, enabling Server Browser Startup, Configuring remote access blah, blah blah. is on a network path that is not supported for database files.Īccording to Microsoft this is a very bad idea and it is not supported. But when you attempt to access an instance on a remote drive you will get the following error. You will be able to directly connect to a SQL Server instance on your local C:\ drive without any problems. mdf file using VB 2010 Express and SQL 2008 Express. The problem with trying to access a remote SQL server instance in code is that you must directly connect to the. Description of support for network database files in SQL Server According to Microsoft you cannot access a remote database using SQL 2008 Express.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |