Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 20th, 2007, 08:11 AM
Registered User
 
Join Date: Apr 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jscammell
Default

I am having a similar issue. I have been attempting to connect a VB2005 Express program to a remote SQL '05 Express DB and I get the error message regarding the "File ....Tracker1.mdf, in located on a network path that does not allow database files." I have researched this and I believe it is being caused because I am trying to use the Data Source Connection Wizard to open my database connection at design-time. I would like to try connecting to the database at run-time using code, but I'm not quite sure how to do so. If you could post a code snippet, I'd be very appreciative.

Details,
Directory to Network shared folder: IPAddy\dev
Filename : Tracker1.mdf
Table Name: Table1
REason for connection: 1.) To Insert new data into database via Windows Form using txtboxes
2.) To Pull data from Database via User designated info ie: Employee Name = John etc.

Again, any help that you can provide would be very much appreciated.
 
Old April 20th, 2007, 08:37 AM
Registered User
 
Join Date: Apr 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jscammell
Default

Just a curious point I found that might add some information to this post, does anyone know how to enable Trace Flag 1807 on the SQL Server Express?





Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a sql 2005 express database twisted f8 Visual Basic 2005 Basics 1 September 13th, 2007 09:49 PM
Connecting to SQL database misskaos Classic ASP Databases 8 October 23rd, 2006 05:57 PM
Connecting to SQL 2000 Database - New at this Tee88 Classic ASP Databases 14 October 2nd, 2004 04:23 AM
Connecting to sql database w/ asp Calibus SQL Server ASP 7 July 8th, 2004 08:37 AM
Connecting to SQL Database rwalker ASP.NET 1.x and 2.0 Application Design 3 December 17th, 2003 02:19 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.