Help-VB.NET and SQL Server 2005

Hai all,

I developed an application software using VB 6.0 at front end and MS
Access 2000 at the

back end. The application runs very slow as the size of the database
increses. I used

ODBC to link the front and back ends, and copied the data base file to
the user's

machine.

Now I plan to re-write the application using VB.NET and SQL Server
2005. Here comes my

problem. My application is a stand alone one. There is no server or
client machines. It

runs on a single computer system. When I develop it I use the
connection string

something like: "Data Source=COM3\SQLEXPRESS;Initial
Catalog=ImgDB;Integrated

Security=True". Even if I use OLEDB or ODBC, I am asked to connect to
the SQL Server. In

my machine I have installed it, so it runs without any problem.

My doubt is this: When I make exe files of my application and install
it on another

machine, that do not have SQL Server, the connection string will be
wrong. Besides, even

if my user's system has SQL Server the computer's name may be
different. So the Data

Source=COM3\SQLEXPRESS part will make an error. It is not possible to
edit the

connection string in an exe file. And I would like to know how can I
port my specific

database to the user's system.

I am a new face in VB.NET and SQL Server 2005. Please help me to solve
this problem.

Thanks in advance for your valuable replies.
.

Relevant Pages

  • Re: SQL Server 2005 connection from VB.NET 2003
    ... This worked with SQL Server 2000, but I'm wondering if this is the problem with 2005. ... Public Function GetRemoteSqlDBConnectStr(ByVal strExtServerName As String, ByVal strExtDbName As String) As String ... I changed the connection string on the PC application to point to the new instance of SQL server, and to my surprise it worked and connected to 2005 without any changes in code. ... Do I have to install anything else on the PC where 2005 is installed to allow access from CE devices, or can I change the connection string / use ODBC instead of SqlConnection? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQL Network Interfaces, error: 26
    ... Just specify you PC name in the connection string ... If you want to connect to SQL Server you need to change ... if you have SQL Management Studio installed ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL Server 2005 connection from VB.NET 2003
    ... Our application is written in VB.NET 2003 and uses SQL Server 2000. ... the connection string on the PC application to point to the new instance of ... installed, Vanputer is name of the database in SQL Server 2005, and User Id ... Do I have to install ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: MSDE2000 - multiple instances
    ... install an SQL Server or MSDE, you define if it is to be a default or named ... Tibor Karaszi, SQL Server MVP ... What do I put into connection string? ...
    (microsoft.public.sqlserver.setup)
  • Re: Parse Large Text File
    ... just did a quick search on sql bulk load, i have sql server 2000, but i ... don't have access to its exe files. ... the sql server is hosted somwhere else. ... the db and just need to run a query on top of it. ...
    (microsoft.public.dotnet.framework.aspnet)