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
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 >>



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 >>


DevelopmentNow Blog