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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|