I'm trying to adapt the code in the article "How to Create ODBC DSN on multiple SQL server Machines" (http://www.databasejournal.com/features/mssql/article.php/2238221) to create a script that will automate the creation of SQL Server DSNs. The article's code writes the DSN to the appropriate l...more >>

I am very new to SQL server. I have successfully installed it on a = server. But when I try to setup an ODBC connection from my client = machine I get the "SQL Server does not exist or Access Denied. " There are two computers on the LAN connecting through a hub. Its probably something basi...more >>

I am getting this message in my SQL Server Agent Error Log. What does it mean[165] ODBC Error: 11, General network error. Check your network documentation. [SQLSTATE 08S01] ...more >>

hi when i try to ODBC into my SQL DB from Excel i get the following error Connection failed: Sql state :'01000' sql server error : 1396 [microsoft][ODBC SQL server driver][named pipes] connectionopen (createfile()) connection failed: SQL state:'08001' SQL server error:1396 [microsoft][O...more >>

having a problem connecting to sql database when we have no internet connection,but we can ping the sql server normally. any suggestion?...more >>

When trying to open a link from the main Web Page of TimberHunt I get the following information: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. /timber_trade/comp_trade_board.asp, ...more >>

I have been attempting to access a database that I have been able to use regularly prior to September 2003. I have tried to resolve this problem through tech support at Microsoft as well as the OEM. I have been unable to find a solution that is more than just temporary. The error msg re...more >>

I am getting an error connecting to my goldmine account when I attempt to login after I was messed up something in my ODBC administrator. When I click on Goldmine, I get a DATABASE ERROR BOX General SQL error Native SQL error:10040 Context: openDatabase MSSQL: xxxxxx.dbo.SPFILES 1. Al...more >>

I've created an ODBC entry for crystal reports. When I go to refresh and run a report, it always prompts me with a select data source and SQL server is at the bottom of the list under dBase, Excel and MS Access Database. If I select it, the report runs. How do I have it automatically choose th...more >>

Any ideas appreciated... Users can export to Excel97 but cannot using ExcelXP. Get error: "unknown token received from sql server" Have patched SQL & OfficeXP locally to current M$ levels. ODBC connects no problem. I'm a tech, not a programmer, so any ideas really appreciated. Jim...more >>

HI all, I am trying to migrate a database from mysql to mssql2k. I use myODBC to connect to mysql server to pull the database from DTS and insert in to sql server. But in mysql server, there is one huge table. Size of it is 1.3 GB and more than 12 million rows. While I try with DTS, i...more >>

I have a stored procedure that as one of parameters receiving the database. I need to change the database that SQL statement in store procedure working on according to parameter. I cant find any solution except fill naming and rewiring whole statement depend on parameter or building SQL statem...more >>

Dear Sir, We have install a database software which require connectivity to SQl Server. After installing teh software we can no longer evoke ODBC under win 2K Pro. Error message " Setup routine for SQL Server ODBC driver could not be loaded due to system code 126" . We would appreciate...more >>

I have altered SQL tables and then relinked them to a Access 2002 front-end and receive the following message "The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time" When the SQL table is altered there ar...more >>

How do i uninstall the sql server odbc driver? After having uninstalled microsoft sql server 2000, its odbc driver is still there and it is conflicting with other pieces of software on my machine thanks...more >>

Hi All: I think there is a problem with the LIKE clause in a SELECT statement. I am using the latest SQL Server 2000 (ver 8.00.760) and Visual C/C++ 6.00 (with SP3) on Windows XP. I created an ODBC connection and tied into a database containing a customer table. The following piece of ...more >>

Hi! I would like to ask for help regarding the error message that I always encounter when I'm trying to restore a database: ODBC SQLState: 42000 The database you are attempting to restore was backed up under a diffferent sort order ID (205) than the one currently running on this serve...more >>

We have a developer that is trying to do a distributed transaction using a View that in turn uses a Linked Server. The Linked server is the MSSQL 2000 server, so both databases reside on the same server. She is receiving the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]...more >>

Hi Folks, How can I invoke a non blocking ODBC query on a table in a SQL Server database. Our current design requires the method invoking the query to 'return' immediately after invoking the query. The results of the query should be put in a globally accessible location. I think SQLFetch is...more >>

Hi Folks, How can I invoke a non blocking ODBC query on a table in a SQL Server database. Our current design requires the method invoking the query to 'return' immediately after invoking the query. The results of the query should be put in a globally accessible location. I think SQLFetch is...more >>

Hello, ============================================ (1) I have added a new table to my database: ============================================ CREATE TABLE SupplierComments ( supplier varchar(30) NOT NULL REFERENCES Suppliers ([supplier]), comments varchar (256), supplierCmtDat...more >>

Hi i'm trying to connect to sql server from client pc, every time gave me msg Unable to connect to server [XXXXXX] ODBC : Msg 0 ,Level 16 , state 1 [Microsft][ODBC: SQL ServerDriver] Timeout Expired Pls help !!! *** Sent via Developersdex http://www.developersdex.com *** Don't ...more >>

Hi, I have a unique (don't we all) situation with Macintoshes talking to my SQL 6.5 server using the very old Visigenic's drivers. Anyway, the problem is that the driver is ignoring the "UseProcForPrepare" flag so all my Macs are creating session temporary stored procedures. Needless to say ...more >>

I have downloaded MS SQL Server for Desktop to upsize my access database to SQL Server database. The upsizing is successful and when I setup the DSN connection. It gives the following error : Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][S...more >>

When creating a new DSN conection to SQL Server 2000 using SQL Server Authentication, user databases do not show up in the default database list. How ever I can access user databases with SQL Authentication login through SQL enterprise and Query analyser. Please advice....more >>

Hi there, I'm looking for a quick way to setup/deploy an SQL alias on multiple clients? Due to an hw upgrade, we are moving our cluster to a new server, and we need to setup on multiple clients a new SQL Client Alias and an ODBC System DSN. I found that Sql Client Alias configuration are st...more >>

People haven't answered my post on 'dev.component', 'programming.component', etc. I don't know where else to post this.. Hello. Somehow my Component Services is all messed up on our productions site. Normally, in test and all other environments I need to click "Identity" in Com+ and put ...more >>

Hi, Our web applications are using COM objects to call sps in SQL server. We are getting a lot of timeout errors. If you know why this happens and any fixes pls let me know. The error looks like following: [Microsoft][ODBC SQL Server Driver]Timeout expired...more >>

I have an unbound form to add new inventory items to a table. With the Access Backend this was fine. Now the backend is SQL Server. The Field [invID] was orignally a Primary Key/Auto Number field in Access. It is now an Int field. I also added a field sqlID as a Primary Key Identity Insert ...more >>

Hi I have a table with following structure Field1 VarChar(10) Field2 VarChar(10) Field3 Text In this table there are 3000 records and for each record the Field3 contains around 50000 to 60000 characters. In SQL Query Analyzer, If I select all the records in the above table, I get thi...more >>

Hi, I am using MS Visual C++/MFC/ODBC and I execute commands like this: CRecordset rs; rs.Open( ..., _T("SELECT .... FROM ..."), ...) Now, I have been compiling and running this in NON-UNICODE mode.. But if I make this UNICODE, my query string will be in unicode. I'm assuming this is t...more >>

Hi, I am getting the below error after a timeout when trying to connect to an SQL Server database. This refers to the connection setup to the database from my asp page. This was working perfectly fine until 2 days ago and this same connection is used throughout the system with out any p...more >>

Hi, I am looking for an easy way to get all of the properties from a SQL 2000 database much like the documenter does in MS Access. Any ideas? ...more >>

Is there an easy way to import an existing Access DB into SQL. The current Access DB is 1GB in size. When I try the upsizing wizard, I get the message that it skipped and/or failed....more >>

Hello, I am hoping you can help me with the following problem; I need to = process the following steps every couple of hours in order to keep our = Sql 2000 database a small as possible (the transaction log is 5x bigger = than the db). 1.back-up the entire database 2.truncate the log 3.sh...more >>

I'm using SQL Server 2K and VFP8. When I save a record, the following ODBC Error Message is displayed. 'Column Name [RefNo] appears more than once in the result column list.' Pls anybody come to my rescue....more >>

Thanks, Pedro Rodrigues pedro@markdata.pt ...more >>

I could really use some help, I have a system dsn and am using the Sql Server 2000 odbc driver. I am getting an error S1000: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt. When I look at the dsn settings, there is a check box to turn off SQLPrepare....more >>

I am having an issue connecting to a SQL server under windows Xp and office 2003. This is the error it gives. **** Connection Failed SQL State : 'HY000' SQL Server error : 0 [Microsoft][ODBC SQL server driver]Cannot generate SSPI content **** Connecting to the same Database on the SQL ...more >>

Hello, I have a stored procedure, that work fine from the Query Analyser. I used it from C code by ODBC api - not all of the rows that supposed to be changed, were changed. so i added SET NOCOUNT ON in the stored procedure, then it worked. After few days i tried it on another computer and i...more >>

Help me! I try to import some data from an informix 5.0 table to Sql Server 2000 with a DTS package. I use Intersolv ODBC driver version 03.011.0021 to connect to the database. It works well, but i can't define a parameter in the sql statement. For example if a try to execute : sele...more >>

Hello . im programing a one application in Delphi . and my program connected to sql server successfully . but thats not why im calling . suppose i exported my program ( .exe ) and sell it . as you know in users pc DSN dosnt exist in odbc . can they open my program without DSN in their systems...more >>

Hi! I've just recently migrated a VB system from Microsoft Access to SQL Server 2000, and a few pieces of code loop through a recordset like the following example: do while not rsRecordset.eof if ...... then rsRecordset.delete else .... (add a new record, or edit ...more >>

Hi, Does anybody know how to write a query using ms access module to retrieve data from SQL Server 2000? How to setup a connection to SQL Server using module ? Please kindly help. Thanks. - Mickey...more >>

wkstn: Win XP SQL Server 2000(local, on wkstn) I'm trying to connect to a PostgreSQL(on RedHat linux server) database using the latest PostgreSQL ODBC driver (07.03.0200) (trying)within SQL server via Import wizard and DTS package...I keep getting this error: "Multiple- step OLE DB operati...more >>

Hi Folks, I've created a SQL Server database and converted it to Oracle (an app we made supports MSSQL and Oracle) and I'd like to be able to provide a "server-side" installation that clients can run on their database server that would automatically create the MSSQL or Oracle database, the t...more >>

2 of the 40 machines in my office have started getting the following error when trying to execute queries on tables linked to Access 2000 from SQL Server 2000. [Microsoft][ODBC SQL Server]Select permission denied on object 'tblname', database 'DatabaseName' owner 'dbo'. (#229) The ODBC ...more >>

Hallo NGs, ich habe bereits die Gruppen durchforstet, aber irgendwie nicht das Richtige gefunden. Situation: Windows 2000 AD Umgebung; Alles in Deutsch; 1 SQL 2000 Server; 1 IIS-Server Auf allen sind der MDAC 2.8, SP4 und alle aktuellen Fixes installiert. Auf dem IIS ist eine ODBC auf den SQL...more >>

I'm trying to execute the following query within a Visual C++ program... SELECT LastName from Employees WHERE LastName LIKE ? In the C++ program, I use the SQLBindParameter() to associate to the ?. The SQLBindParameter() variable used contains 'A%' (without the single quote). This is ...more >>

I keep randomly getting the following error when I am processing read only and read/update queries through a reporting tool: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream. I know that it is not the queries themselves, because if you re-process, it will ususally go through. I've...more >>