all groups > sql server odbc > march 2004 > threads for march 1 - 7, 2004
Filter by week: 1 2 3 4 5
Re: Occasional "Timeout expired" message - on SP that should take 1 second
Posted by ITFred at 3/5/2004 5:36:45 PM
I have been struggling with a similar problem for a couple of weeks and
came
to this group in search of a solution. Perhaps a pooling of information
will help.
In my situation, I have a VB interactive front-end on multiple machines
accessing a SQL2K database through ODBC over TCP/IP. ... more >>
Cannot connect to SQL Server through VPN
Posted by Paul Ohlemacher at 3/5/2004 5:13:05 PM
I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sq... more >>
Can't connect ODBC/SQLSrvr linked table from within COM+ component
Posted by Raf at 3/5/2004 4:41:07 AM
I have an Access 2000 database containing an ODBC table linked to a SQL Server 2000 database (using a system DSN)
No problem opening the table Using Access 2000 itself
No problem even within a VB program (EXE) accessing that table using the following code
Set rs = New ADODB.Recordse
... more >>
Unknown Token Received
Posted by Greg M. at 3/5/2004 12:17:30 AM
I have a client using SQL 2k, SP2 (due application requirements, SP3 is not
an option - the application vendor will not specify why). We are receiving:
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
Connection Broken
There doesn't appear to be any rhyme or reaso... more >>
ODBC vs OLE DB
Posted by samuel at 3/4/2004 2:56:47 PM
The ODBC processing via DTS is slower than OLE DB which resulted following
inquiries:
- Why it so slow (ODBC)?
- Any idea how to overcome it
I use ODBC to communicate between IBM AS/400 DB2 and MS-SQL Server 2000.
Please advise.
Thanks.
... more >>
ODBC system dsn problem
Posted by bill at 3/3/2004 11:10:21 AM
We have a client that is trying to connect to a SQL DB on
a Win2003 server (thru Citrix) using a system dsn. When a
user tries connecting using the system dsn in Crystal
Reports (or anyting else for that matter), they get the
following error: data source name not found and no default
drive... more >>
Login failed for user '(null)'...Reasons?
Posted by JRE at 3/3/2004 10:27:44 AM
A SQL Server (in another domain) I'm trying to connect to with SQL Server
authentication (UID and password) fails from an Access application. I've
tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
mixed authentication mode.
I can get to the SQL Server with Enterprise Man... more >>
SQL Driver Question
Posted by Sunden at 3/3/2004 6:08:34 AM
Hello!
Not as verse in SQL as I'd like to, but keep learning
everyday.
When creating an SQL driver, two options appeared to be
checked by default, "Use ANSI quoted identifiers" and "Use
ANSI nulls, paddings, and Warnings check box". Should
they be left alone or should they be unchecke... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Create a DSN programmatically with network options
Posted by Patrick_Mézard at 3/1/2004 8:20:47 PM
Hello,
I would like to create a brand new system DSN, programmatically,
targeting an MS-SQL Server 2000 database, and with networking options
(pipes,TCP/IP, etc.).
Until now the only solutions I managed to find on google.groups or
forums are:
1- The usual "Why don't you do it manually ?" ... more >>
SQL 7 and MDAC
Posted by MG at 3/1/2004 1:17:02 PM
I am running into MDAC discrepencies between my client
workstation with SQL 7 client and production and test sql
7 servers.
I have realized that my workstation (Windows2000) has MDAC
2.6 and the production box (which is NT4) has MDAC 2.12. I
also have a test SQL Server 7 server with Wind... more >>
|