Re: VB Express can't connect to anything

Hi Birk,

If you are distributing SQL Server 2005 Express with your software then you
can fully configure all options to allow remote connections at setup. Really
no need for your users to do anything manually. Just look up the
DISABLENETWORKPROTOCOLS option in the following articles:
http://blogs.msdn.com/sqlexpress/archive/2006/09/20/configuring-sql-express-during-installation.aspx
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn.microsoft.com/msdnmag/issues/04/10/bootstrapper/

In my opinion it is a good idea to disable remote access by default. That
helps to improve security.

As for the problems with your connection you can check the Windows event log
and the SQL Server log files for any error messages. Also, try connecting
with the SQL Server Management Studio to see if it will work.

Regards,

Plamen Ratchev
http://www.SQLStudio.com


"Birk Binnard" <birkb@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e88YJJMOHHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
Thanks, but after several hours of reading and experimentation I am still
unable to get VBExpress to run any application that uses any SQL database.
Even the DVD Collection template fails to run properly -- it starts and
ends with no screen output at all.

My original objective was to convert an old Access application to a
stand-alone EXE that would be easily portable (and saleable) to clients
with no software installed other than regular Office. I initially tried
to get VBExpress to connect to my Access MDB file, but was unable to do
this (the dialog box that builds the connect string doesn't work.) So I
thought I'd try SQLExpress figuring VB needed something that was .Net
compliant.

After this experience its clear I'd be much better off converting the
Access tables to plain old VB data files. That way my app will be
independent of other software and I'll be able to ensure it will install
and work OK the first time.

It does seem odd that MS would allow "sample" software to be distributed
that in fact does not work immediately following installation. The fact
that there are KB articles explaining how to make things work is shocking.
I know that if I tried to put software like this in a client's environment
I'd be out of business in no time.
--
Birk Binnard
http://www.birkbinnard.com


.

Relevant Pages
Loading