Re: VB Express SQL Express Remote Connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks for the response
I'm sorry but I can't access the link you provided. Can you provide me with
some additional information or a different link.


"Cor Ligthert [MVP]" wrote:

Cleo,

The server should be reachable by its Server name. Not as by the Jet engine
(access) with its file address.

It is in fact much easier than with Jet.

Why not try this one first, after doing this you can see almost everything
that is hapening.
http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252

I hope this helps,

Cor

"cleo" <cleo@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:C419FC01-3A37-480C-B624-671FEC553530@xxxxxxxxxxxxxxxx
I am migrating from VB6/Access to Visual Basic and SQL Express. I have
success writing test code on my local machine and am now setting up tests
for
deployment to a server. I have installed SQL Express on a Windows 2003
Server. I can connect and create databases on the Remote Server from my
local machine using SQL Management Express, so I know Remote Access is
working.

However, I am unable to connect using a connection string within my VB
Express program. I am using the SQL Connection String Builder with the
properties

Dim cn as SQLClient.DBConnectionStringBuilder = new
SQLClient.DBConnectionStringBuilder
cn.DataSource = "AppServer02\SQLExpress"
cn.ApplicationName = "VBTest"
cn.AttachDBFilename = "testdb.mdf"
cn.IntegratedSecurity = True
cn.PersistSecurityInfo = False

The error I receive is
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote
connections.

I understand that VB Express does not support Remote Connections through
the
Designer, but I thought I could connect to a remote database using a
connection string.

Your help is appreciated






.

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this error: ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central o
    ... Looking for a SQL Server replication book? ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)