sql 2005 express remote access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

josh@adnetss.com - 29 Nov 2006 18:31 GMT

I'm pretty new to both sql 2005 and VB but please bear with me. I have
installed SQL 2005 express on a Windows 2003 Standard server. I have
also installed VB 2005 Express edition on the server. SQL seems to be
running fine (I can create databases, tables, modify them, etc.) I have
created a very basic app in VB express that just lets me view and
modify the current tables. It works just fine on the server. However, I
am trying to make this app connect from an XP pro machine on the
network and I really don't know where to start. I tried running the app
that works locally over the network and I get "error 26" can't connect
to database server. I've read about using strings and ADO but I'm not
familiar enough with VB to make it work. Also, both machines are on the
same network and I can connect to the server from the XP pro machine
with SQL server management studio express.

Any help is greatly appreciated.
Thanks,
Josh

Reply to this Message

Arnie Rowland - 29 Nov 2006 18:37 GMT

These articles should help you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

> I'm pretty new to both sql 2005 and VB but please bear with me. I have
> installed SQL 2005 express on a Windows 2003 Standard server. I have
[quoted text clipped - 13 lines]
> Thanks,
> Josh

Reply to this Message

Jay B - 29 Nov 2006 19:00 GMT

usually there is an .ini file that should be distributed with your app
that would contain the sql server information needed to connect to the
sql server. your program should read this file for the sql information,
be it a dsn entry or the actual sqlstringconnect() setting and issue the
call the connect to sql. this is what i do in my apps.
i do not use the new vb2005 so dont know if there's a shortcut in db.

> I'm pretty new to both sql 2005 and VB but please bear with me. I have
> installed SQL 2005 express on a Windows 2003 Standard server. I have
[quoted text clipped - 13 lines]
> Thanks,
> Josh

Reply to this Message