Re: VB Application Migrating from Workstation on XP to Server runn
- From: "Dave Patrick" <mail@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Apr 2005 14:01:05 -0600
You'll have better luck in the VB development groups.
Follow-up to: microsoft.public.vb.general.discussion
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"smfpphd" wrote:
| Dave,
|
| I'm not sure if you want to see the connection string, but all that was
| changed in it was the data source (from when it was working on the work
| station). It was:
|
| Conn.ConnectionString = "Provider=SQLOLEDB.1;" & _
| "Persist Security Info=False;" & _
| "User ID=sa;password=Admin;" & _
| "Initial Catalog=OilChanges;" & _
| "Data Source=(local);"
|
| now it is:
|
| Conn.ConnectionString = "Provider=SQLOLEDB.1;" & _
| "Persist Security Info=False;" & _
| "User ID=sa;password=Admin;" & _
| "Initial Catalog=OilChanges;" & _
| "Data Source=CHEVYOFFCSRV\SQLENGINE1;"
|
| Thanks!
|
| Sue
|
|
|
| "Dave Patrick" wrote:
|
| > Either case no one will know without seeing the code hence the
suggestion of
| > the VB development groups.
| >
| > --
| > Regards,
| >
| > Dave Patrick ....Please no email replies - reply in newsgroup.
| > Microsoft Certified Professional
| > Microsoft MVP [Windows]
| > http://www.microsoft.com/protect
| >
| > "smfpphd" wrote:
| > | Thank you , Dave. I wasn't sure if it was a VB or an SQL connectivity
| > problem.
| > |
| > | Sue
| >
| >
Try posting the relevant code to one of the VB development groups.
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"smfpphd" wrote:
| Hi,
|
| Has anyone had any problems when migrating a VB application from an
| workstation with XP running as a server for MSDE to an actual server
running
| SQL Server 2000 with SP3. I can get the program to run on the server,
| howver, when I try it from one of the clients, I get the error message
| -2147467259 DBNETLIB ConnectionOpen (Connetc()) SQL Server does not exist
or
| access denied. I figure it is something about the Named Pipes, but I have
it
| set to port 1433. I appreciate any and all assistance.
|
| Sue
.
- References:
- VB Application Migrating from Workstation on XP to Server running
- From: smfpphd
- Re: VB Application Migrating from Workstation on XP to Server running
- From: Dave Patrick
- Re: VB Application Migrating from Workstation on XP to Server runn
- From: smfpphd
- Re: VB Application Migrating from Workstation on XP to Server runn
- From: Dave Patrick
- Re: VB Application Migrating from Workstation on XP to Server runn
- From: smfpphd
- VB Application Migrating from Workstation on XP to Server running
- Prev by Date: Re: VB Application Migrating from Workstation on XP to Server runn
- Next by Date: System Start up
- Previous by thread: Re: VB Application Migrating from Workstation on XP to Server runn
- Next by thread: Propagate Folders Permissions
- Index(es):
Relevant Pages
|
