Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cwightman
Starting Member
6 Posts |
 Posted - 2003-04-14 : 09:11:41
|
| HiI need help my programmer has been moved to another building in another town. She has her old pc etc. But she is unable to connect to her application anymore. The connections to sql server are fine as she is able to use them through enterprise manager.But she can only access the application now when the initial connect string fails which uses trusted connection and returns the dialogue box, by selecting the same server it then connects.I'm at a loss as to why the application now requires the dialogue box to be used for her, yet for people at the site where the application is based its connecting as you would expect through the programme.Anybody able to shed some light on this I would be gratefull.Thanksclive |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-14 : 12:26:33
|
| We're going to need some information about the connection. Since it works fine through EM, the problem isn't with the network, it is with the application or with some configuration setting. Please explain how the application connects to SQL Server.Tara |
 |
|
|
cwightman
Starting Member
6 Posts |
Posted - 2003-04-15 : 05:37:39
|
| Tara thanks for replying.Its a visual foxpro application and the connect string is..m.string='driver={SQL Server};server='+connections.server+';uid=;pwd=;database=ic'nchandle =SQLSTRINGCONNECT(m.string).The connections.server is located in a fox table on the server running the app incase app needs to be pointed to another server.The server the application executables etc or on is different to that of our sql server machine.Clive |
|
|
|
|
|
|
Connection fails after move??