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 |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2002-03-28 : 16:07:05
|
| Connectivity error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact (GetOverLappedResult())Ron Grzywacz |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-03-28 : 16:17:06
|
| With this wealth of information to go on I was able to turn up two possible KB articles from Microsoft.[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165621[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q230568[/url]If neither of these address your issue you may have to break down and give us some more details before we can help.Justin |
 |
|
|
rongrzywacz
Yak Posting Veteran
57 Posts |
Posted - 2002-03-28 : 17:22:14
|
| Neither article seem to address the problem. We have a Visual foxpro app with about 100 users accessing the DB.The errors seem to come in bunches, where we will see a bunch in the application error log, then everything is fine for a few hours, then we will see a few more. Can't see a pattern. The queries being run at the time are mostly simple select 1 row type queries. Tanks for any help. RGRon Grzywacz |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-03-28 : 17:47:39
|
| How are you getting SQL errors when querying your VFP tables? Is it a linked server? Are you (somehow) using the SQL ODB driver to talk to VFP?It sounds like you probably have some sort of VFP locking issue. With 100 users, you'd probably want to move away from VFP ASAP and get it all into SQL. Michael |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-03-28 : 17:48:11
|
| This maybe of a little bit more help. Its a long shot but considering FoxPro's xBase roots and the mention of "cursor" in the article it could be worth a look.[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165621[/url]hth,JustinEdited by - justinbigelow on 03/28/2002 17:49:03Edited by - justinbigelow on 03/28/2002 17:49:42 |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-28 : 19:17:12
|
| I don't know anything about ConnectionTransact, but I do know that a lot of people run into connection errors when their system is supposed to be using the TCP/IP connection library but instead is attempting to use Named Pipes (which appears in your error message). Perhaps you can disable the Named Pipes Library or find a way to make sure your connection is using TCP/IP (dbmssocn) library instead.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Connectivity error ??