Re: VB Express SQL Express Remote Connection

Yes I can connect using the SQL Server Management Studio Express Tool.
I changed my connection to exactly what you specified and it connected.
Then I went back to my original connection string - All I had to do was
change Integrated Security = True to Integrated Security = SSPI and it works.

Thank you.

"Cor Ligthert [MVP]" wrote:

Cleo,

Can you install this tool and than try to attach the file to the database
server

http://msdn.microsoft.com/vstudio/express/sql/download/

You are now using it in a kind of Access way.

I don't use that tool, but as you have done that, than your connection
string becomes something as

strConn = "Server = YourServerName/SqlExpress;Database = NorthWind;
Integrated Security = SSPI;"

I hope this helps,

Cor


"cleo" <cleo@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:0B5B7CDB-9FE8-4C98-BA88-DFDCEF7C0FE8@xxxxxxxxxxxxxxxx
Sorry for the double post. No I don't use a proxy.

I have added typed datasets using a local SQL Server Express instance -
these all use the Data Source=.\SQLEXPRESS and work fine. But now I want
to
connect to a production Server instance named AppServer02\SQLEXPRESS. The
Add Data Source Wizard errors with the message The file
\\AppServer02\SharedDatabases\textdb.mdf is on a network path that is not
supported for database files.

Will VBExpress allow me to connect to a SQL database that is not local?

thanks for you time.

"Cor Ligthert [MVP]" wrote:

Cleo,

Thanks for your information one other question?

Do you use a proxy or whatever like that?
--------------------------------------------------------------------------
There is not so much text on that page by the way, it is this.

This sample is usable for more than only the Faq, but you can make that
sample yourself.
--------------------------------------------------------------------------------

Open a new project.

Click on Data -> Add New DataSource and follow the wizard
Click on Data -> Show Datasources
Drag from the at the left opened window your table to the form
Set in Solution Explorer the Show All files Icon to show all files

You have now a lot of samples with a strongly typed dataset

Cor

"cleo" <cleo@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:6B2D8E44-EDB7-452F-A99D-294CBD3D2AFA@xxxxxxxxxxxxxxxx
I just receive the general error "This Page cannot be displayed." I get
it
when I click on the link and when I google into vb-tips.com. I am
using
Windows XP and Internet Exployer

"Cor Ligthert [MVP]" wrote:

Cleo,

Can you tell me why you cannot access that link?

Because it is the website from Ken and me.

Thanks in advance

Cor

"cleo" <cleo@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:145A9D42-7F3F-49F0-937B-F227492A67FD@xxxxxxxxxxxxxxxx
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: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Access and ISA Server in SBS 2003?
    ... I am glad to hear the Remote Access Wizard is working fine now. ... there is no difference in VPN between SBS 4.5 and SBS ... Error Message: VPN Connection Error 800: Unable to Establish Connection ... the external NIC of the SBS Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote Office Configuration Suggestions?
    ... Welcome to SBS newsgroup. ... I understand that you want to keep the remote office continue working even ... after the main internet connection on the main office is not available. ... If you want to join the remote server to a SBS domain and become a member ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ... > Connection Manager to connect to the VPN server and gain access to a shared ...
    (microsoft.public.windows.server.sbs)