VB Express beta2 and sql db creation problems
I'm trying to learn visual basic, via the how-to's in VB express. I know zip about sql, and little about databases in general.
Here's the problem. In an exercise to create a Windows form containing a sql database, I keep getting "Cannot connect to database. Server timed out." error messages.
1. What server? It's just me & my laptop.
2. At least, I'm no longer getting "User does not have permission" errors.
How do I need to configure services, permissions, sql express, etc. to get things to work?
I'm running XP SP2 Pro.
Thanks in advance.
[599 byte] By [
piaqt] at [2007-12-16]
Hi,
I'd like to understand more about the excercise you're trying that is timing out. I'll take a shot but I'd appreciate any context you can give.
1) the server in the error message is SQL Express. SQL Express is a server and an engine that is great for local data access, e.g. enabling connections to a database for a single application on the local machine. Did you install SQL Express with VB Express? This could be the problem.
2) excellent. we invested a lot in being able to use local databases under Normal User privs with SQL Express. This helped avoid the permissions error.
My guess is you're missing SQL Express on your laptop, or you're trying to work with samples based on SQL 2000. You'll need SQL Express 2005 to work with VB Express.
For getting started information, please read my blog entry on local data:
http://blogs.msdn.com/pauly/archive/2005/05/10/416173.aspx
Let me know what I can do to fill in more details.
Best,
Paul Yuknewicz
Visual Basic
Paul:
First, thanks for the response.
Sql express is installed, the latest beta. The exercise is called, "Creating your first database."
As I am not running a server, which services need to be run, how do I set permissions (and which ones) and do I need IIS installed?
Also, how should I configure the SQL surface?
