Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008


all groups > sql server connect > november 2004 > threads for november 1 - 7, 2004

Filter by week: 1 2 3 4 5

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
Posted by Brent Stevenson at 11/5/2004 8:25:33 PM
We are randomly experiencing this error when connecting to SQL W2K from web servers using ODBC. I see numerous links on the web but real answers. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()). ...more >>

Problem connecting to SQL server
Posted by joep NO[at]SPAM i-f-s.com at 11/5/2004 2:04:38 PM
Using a UDL ,on a WIn2K machine, I attempt to connect to SQL server (Sql server 7) CLicking on the "test connection" button returns connection failed with the error message : Test connection failed because of an error in initializing provider. Client unable to establish connection If I create...more >>

How to get source IP address of a database connection
Posted by Jacek Ska¼nik at 11/5/2004 10:50:39 AM
Hi, Is there a way to find out the source IP address of a database connection? In trace there are only netbios names available, while I need to log the IP addresses that connect to the database. Thx, Jacek Skaznik ...more >>

Detect servers on the network?
Posted by William Sullivan at 11/5/2004 7:45:05 AM
I'm wondering how to detect SQL servers on the network, the way Enterprise Manager locates servers when it populates combo boxes or list boxes with active servers on the network. Can anybody give me a hint? Some C# code would be a plus. Thanks!...more >>

Invalid authorization specification
Posted by AUMFC at 11/4/2004 8:43:09 AM
MS OLE DB Provider for SQL Server Error: Invalid authorization specification This is a basic 3-tier system, front end, data broker, database. The front end software is written in VB 6. There are many front end users. This error is coming up on one computer only. No users can access the da...more >>

Machine Name Change slows ODBC link intolerably
Posted by reclusive.monkey NO[at]SPAM gmail.com at 11/4/2004 2:39:01 AM
Hello Everyone, I have had an ODBC link between Access and Oracle at work for some time now which has worked without problem. The other day, one of our technicians came to change the name of my machine. Despite my best efforts, I could not keep him off my machine and sure enough, my ODBC link...more >>

Urgent! - How to correctly connect a linked server to Access mdb with DB-Password?
Posted by Martin Schmeller at 11/2/2004 10:46:02 AM
Hi! I'm not able to create a linked Server to an Access mdb with DB-Password! I already tried the full OLEDB-Provider string with " ... ;Jet OLEDB:Database Password=NOT4ALL" I get the error: OLE DB-Fehlertrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x800...more >>

BackUp - Device Activation Error
Posted by Ajit at 11/2/2004 10:33:38 AM
Hi, I am trying to restore a database from a different server to my server and also with a different name. But it gives me an error. ODBC-SQLState 42000 Device Activation Error. Does anyone know what this is ? Any help is appreciated. ...more >>



Linked server to oracle doesn't fetch correct datavalues
Posted by GP at 11/1/2004 10:40:04 AM
I am using the open query method to connect a Oracle server. Below is my code to connect to oracle,when I execute the same query in oracle it fetches 199 rows whereas in Sqlserver it returns only 66 rows. I have tried only one record based on id..sqlserver query returns 0 rows..whereas the ora...more >>

Linked server to ACCESS97
Posted by ChrisC NO[at]SPAM EP at 11/1/2004 5:59:01 AM
Hi, I can get data from local MSDE2000(called SW_ENGR) with local linked server on C:, but failed to get data from MSDE with linked server residing on a NT mapped drive E:, I guess it is a permission issue, but don't know how to get it right. Here is the situation: I have MSDE2000 run...more >>


DevelopmentNow Blog