all groups > sql server odbc > september 2006
Intermittent "Data source name not found", only when under heavy l
Posted by cafdev at 9/29/2006 3:19:02 AM
Running a 6 node Microsoft ASP (pre - .NET) application running SQLServer
2000 with up to 1500 users. When user load starts to peak, we're getting
'Data source name not found and no default driver specified', but the problem
is intermittent.
Are you aware of any scenarios in which this s... more >>
odbc open query syntax to db2
Posted by Bill at 9/28/2006 8:56:25 AM
Ok all you Gurus,
Here is a problem we are having, we have a sql server 2000 and we have
another server which is a DB2 server. The db2 server is linked. We are
trying to run an open query and I do not think I have the right syntax
to accomplish this task. Please see query following
go
SEL... more >>
automate way to build an odbc connection
Posted by Sam at 9/28/2006 12:00:00 AM
is there is an automate way to build an odbc connection without usin the
windows "odbc data source administrator"?
thanks
... more >>
ODBC: Call Failed 3146
Posted by Johan at 9/24/2006 2:54:21 AM
Hello,
I have a vb program that connects to odbc to an sqlexpress server. When
i try to write data to the db, i get this message:
Release Error: Script #1 (Ascent Capture Database) [3146 Index Table
(dbo.DIGIDOS): ODBC: de oproep is mislukt.]
"de oproep is mislukt" is dutch for "Call fail... more >>
ODBC BCP Error Handling in C++
Posted by TLunsf at 9/20/2006 11:34:01 PM
(Please let me know if there is a better group to post this on...)
I have written a C++ program that BCP's data into SQL Server using ODBC.
I'm currently at the point that I am testing worst-case scenarios. In the
scenario that while the BCP is running, I pull the network cable from SQL
s... more >>
Connection problems to SQL2005 with odbc using port 1733
Posted by Jon Haakon Ariansen at 9/20/2006 12:00:00 AM
Hi,
I'm trying to connect to a SQL2005 server inside a firewall from another
Windows2003 server that is placed in DMZ. Both servers is hosted by our ISP
but they can't seem to find the problem.
Because the sqlserver is used by many companies we have to communicate with
the sql server on ... more >>
ODBC Connection Problem
Posted by mik18 NO[at]SPAM pitt.edu at 9/19/2006 7:15:05 AM
Hi all
I'm attempting to setup a linked server to a cache database within
Enterprise Manager. I setup an ODBC driver on the server and the
connection worked when tested.
Selected Micorsoft OLE DB Provider for ODBC Driver from the drop down
list.
Entered the data source name in the Data Sou... more >>
help with emergency--sql server 2000 sp4
Posted by c676228 at 9/17/2006 10:30:01 AM
Hi everyone,
Our site is running fine until our hosting company applied sp4 to our sql
server 2000 on windwows 2000 server. It seems that our asp program cannot
talk to you sql server 2000 any more.
the error message is like this:
line 13 is the source of error message and I marked with *
Th... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQLBrowseConnect and Trusted_Connection=yes, Bug?
Posted by Scott Willeke at 9/17/2006 12:08:01 AM
I am trying to use SQLBrowseConnect to obtain a list of databases on the
server with Trusted_Connection=yes in the connect strings. I am unable to get
it working. I can get it working when not using trusted connection. I found
lots of other people complaining about this on the net, but nobody ... more >>
pb odbc error
Posted by powerbuilder99 at 9/16/2006 4:08:45 AM
>"[Microsoft][ODBC Driver Manager] Program Type out of Range"
... more >>
ODBC - SQL Server 200 - MFC - Visual C++.NET (2003)
Posted by Florin at 9/15/2006 12:32:02 PM
Hello!
My problem is:
In Sql Server I made a table "Nir" with 3 columns:
Nr_crt - numeric
Val_TVA - numeric
Val_Tot - numeric
In SQL Server the command:
SELECT SUM(Val_TVA) AS Val_TVA, SUM(Val_Tot) AS Val_Tot FROM Nir - returned
me a result with 2 sums... OK!
My... more >>
limit on sp's through an odbc connection
Posted by Bill at 9/13/2006 7:29:56 AM
To all the gurus,
Is there a limit on the number of queries that can be run through an
odbc connection to another SQL server?
The primary server is running abinitio to query a sql server.
When we run the set of sps that is needed the server essetially grind to
a halt...
thanx
Bill
... more >>
crystal report exits on access MS-SQl server 2000 and 2005 with O
Posted by Sanjeev Kumar at 9/11/2006 11:39:01 PM
Setup details:
Crystal report : 8.5
Ms-Sql server 2000 and 2005
Crystal report uses MSSQL ODBC driver to get the data from database and
displays in crystal report. When i have large number of data the crystal
report exits after 1 hour. In the temp folder of windows file is created once
it c... more >>
Stored procedure output to MS-ACCESS in SQL Server 2000
Posted by santhoshks NO[at]SPAM gmail.com at 9/8/2006 1:55:05 PM
I have a stored procedure which upon execution, the output needs to be
wrote onto a .mdb file..i need to do this as writing it through
MS-Access data component makes it very slow when used in c#.
... more >>
Import Visual Fox Pro to SQL 2005
Posted by HelpVisualFoxProPerson at 9/8/2006 11:04:01 AM
Is SQL Server 2005 compatible with Microsoft Visual Fox Pro Driver
6.01.8629.01. I am trying to import data from a fox pro db into sql server
2005 when I go through the Tasks import the data source is not available. Can
I create a data source for Visual Fox Pro.
Please help. ... more >>
Remotely installing DSN
Posted by MatthewWilsonAPD at 9/8/2006 8:24:02 AM
Is there any way to install a System DSN to all the pcs on my 2003 network?
(clients running xp)
either by a GPO or something else?]
i dont want to have to go around every pc doing it... more >>
Import Visual Fox Pro .dbfs to MS SQL Server
Posted by HelpVisualFoxProPerson at 9/8/2006 8:15:02 AM
I am trying to import .dbf tables from Fox Pro imto SQL
SELECT *INTO #People FROM OPENROWSET
('MSDASQL', 'DRIVER={Microsoft fxopro vfp Driver
(*.dbf)};SourceDB=q:\Learnast\dbfs','SELECT * FROM people')
here is the error message I receive
OLE DB provider "MSDASQL" for linked server "(n... more >>
Missing File
Posted by PeeJayEll at 9/3/2006 8:49:58 PM
I am trying hard to get my downloaded SQL server express working.
I need to have use of the reporting services.
This appears on my start menu, but clicking it gives a message that
devenv.exe is missing and can't be found anywhere.
Where does devenv.exe come from - how can I get hold of it?
... more >>
SQL linked server with ODBC
Posted by Vanbever at 9/1/2006 2:36:35 PM
Hi,
I am having trouble extracting data from a Navision
database via an sql linked server. I am using sql server 2000.
The steps I have followed so far are;
I installed the codbc driver, (the odbc driver which comes
with navision), on the sql server.
I created an ODBC System DataSource n... more >>
SQL error
Posted by Simon at 9/1/2006 8:24:02 AM
I am attempting to run a stored procedure which inserts data on a remote
server but I`m getting the following
Server: Msg 7391, Level 16, State 1, Procedure ETrackerExportRoutine, Line 38
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distri... more >>
SQLConnect
Posted by Weston Fryatt at 9/1/2006 8:20:22 AM
Environment:
Windows 2003 Enterprise Server (Production Server)
SQL Server 2000 Standard Edition (with Service Pack 4 installed)
Windows 2003 Enterprise Server (Test Server)
SQL Server 2000 Enterprise (with Service Pack 4 installed)
I'm getting three different ODBC error:
... more >>
|