Re: How can I have a user select a local MS SQL database using vb.net? TIA SAL

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Cor Ligthert (notmyfirstname_at_planet.nl)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 12:32:16 +0100

Sal,

For the connectionstring it is easy, you can set those in the first event
that takes place in your program. By instance the load event of your startup
form. (And do not delete the ones which are created using the designer when
you did that in that way, that gives problems afterwards while updating your
program).

For the datatables I know only the solutions of creating them using the
command.executenonquery and SQL statetements with "Create Table etc) or with
a SQL script.

The firs approach is in my opinion efficient with a single user situation,
than you can do in a special installation section, where you than as well
set directly your connection string in the registry.

In the script approach I would set the connection string in a config.file.

Just my thought?

Cor

"sal" <sal@spp.net>

> Greets
>
> I have sucessfully created a sql database and vb.net program locally
> connecting to my local server.
> (I used visual studio 2003)
> I would like to send the database along with the compiled vb.net code to
> the user. The problem is the users
> machine and msde server are going to have different names. How do I
> change
> this in my code to have
> the user select thier sql server and sql database located locally on
> his/her machine.
>
> PS the user will have msde installed
>
> TIA
>

Relevant Pages

  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)
  • Re: Timeout problem with SS2K, VS03
    ... I noticed calls in sql profiler: ... This is the server side debug stored procedure. ... a timeout issue that I cannot identify the source of. ... transaction is committed and the connection is closed cleanly and all ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... listening on UDP 1434 using netstat -abn, ... And i double checked the connection string, and i did have it the right ... But I have another 2000 server that I can connect to fine, ... I am trying to connect from an XP SP2 machine remotely to a SQL Express ...
    (microsoft.public.sqlserver.connect)