ODBC Beginner Normal I use: sprintf(qu,"SELECT Name, phone FROM PersonTable WHERE info='%s'",sText); SQLExecDirect(hstmt1,qu,SQL_NTS); This works fine, except when the sText is: Test on 'data' field Then I have the ' in the string. What else can I use - SQLPrepare?. Please give me some s...more >>

There are two tables table A & table B. There are two indexes defined on each of these tables. As I insert records into the tables (ODBC programming), I notice that occassionally the time required to insert the records is very high. Normally, the time required to insert records into the two ta...more >>

I have been trying on an off for a month to connect to an MSDE (SQL server) database from a remote computer with ODBC. I can connect just fine from within the workgroup. In Cliconfg, I have set up an alias pointing to servername.com\INSTANCENAME. tcp/ip is set. There is not a firewall in pla...more >>

Hello, I have a MySQL database residing on a Linux box and a MS SQL Server residing on a Win 2000 box. I have installed a MySQL ODBC driver that works fine with ACCESS, however when I try to use that same Driver in SQL Server (as a Linked server), I get errors. For example, in Query A...more >>

Hi, I am currently transfering a db from Access 2000 to SQL server 2000 ( Developer Edition) I used the import feature and this seems to have worked ok, but having a problem with a couple of queries I am connecting using ODBC and RDO from a vb program, and passing this query to the serve...more >>

When I configured the System DSN, seems no matter what case I entered the password in, they all worked. Does that mean, password is not case sensitive on SQL Server? Bing...more >>

http://www.microsoft.com/sql/reporting/productinfo/trial.asp If you have a SQL 2000 license, you can use the software. I don't work for Microsoft, but I am excited enough to see this that I wanted to send out the link. I have been waiting a long time to move beyond the limits of Infomaker or...more >>

I am having a great deal of difficulty accessing individual fields generated from a Sql Server 7 view. When I specify the actual field name, I get the error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'inventory_h...more >>

Hi all, I have 2 PC. One of them install SQL Server2000 and the other one acts as client. Currently, these 2 PC have connected to company network and I can connect from client PC to server via ODBC. One day, I connected 2 PC via cross-cable. Then I cannot connect to the server anymor...more >>

I´m randomly getting the following error in my development environment: error '80004005' [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite(WrapperWrite() My platform is: Windows 2000 Server SP4 + SQL Server 2000 I´m developing a 3-tier system, using IIS 5 and VB6-...more >>

I have an Access 2000 application that connects to a mixed mode SQL Server 2000 database. I connect via a SQL autentication DSN and a co-developer connects via a Windows autentication DSN. We both connected fine until my co-developer copied the Access application to make changes. Now it seems th...more >>

I get this error when setting up the ODBC connection: the setup routines for the SQL server ODBC driver could not be loaded due to system error code 126...more >>

Does anyone know how to ensure a persistent login?? I have a MS Access application utilizing a SQL 6.5 database. I've created the odbc driver and have successfully connected using MSQuery from a desktop running MS 98. However, each time the Access application connects, I'm forced to log...more >>

I'm reposting this because i tried deleteing the table manually and recreating it manually. It works OK after that, but when i try it again, it gives the error again. There are four tables, but it only happens on the "ITEMS" table. I'm trying to execute the following code and i am getting th...more >>

How can I check if table already exists in a DB? Today I just create my table at startup, if it exist I get a error telling me that the table already exist, ignoring the error message. But this is a dirty way of doing it. Any other idea. It must be quick and clean. ...more >>

I need to understand how I can save an excel spreadsheet in the SQL 7.0 db. Am I trying to save the XLS file or just a link to it?? I have a VB6 front end to the SQL database. Thanks ...more >>

We have an application which suddenly broke, I am trying to find out if anyone updated MDAC or similar on the box but don't know yet. When certain stored procedures are called I get an error OLE DB provider for ODBC expects parameter xxx which was not supplied. This only just started happeni...more >>

I have 50 users connecting to SQL server via ODBC using TCP/IP to connect. But 2 of the users accounts keep on having their windows accounts locked out. Any suggestions?...more >>

I'm creating a DTS package that i can schedule to run everynight. i'm using activeX vbscript to check expiration date on all the customers in a database if the they have expired to change them member circle status. I keep getting a time out error on the first update. I have no idea why. can some...more >>

Have 3 XP machines running Office XP Pro. The odbc file dsn sits in same file as the mdb on a server (on purpose so it gets backed up regularly). The odbc file connects to an SQL 7 database on an NT4 machine. All sql driver versions are 2000.81.9042.00 The authentication is an sql acco...more >>

Hello.. I use command BCP rceiving the following error : (SQLState = S1000, Native Error = 0 Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver version mismatch) ...more >>

I'm trying to execute the following code and i am getting this error: "Run-time error '3211'; The database engine could not lock table 'Items' becuase it is already in use by another person or process". This code is being executed in AccessXP using an ODBC connection to a server DB. I'm not...more >>

I'm trying to execute the following code and i am getting this error: "Run-time error '3211'; The database engine could not lock table 'Items' becuase it is already in use by another person or process". This code is being executed in AccessXP using an ODBC connection to a server DB. I'm not...more >>

Hi, I have a simple SQL script that creates a database and some tables, and is called via ODBC from within my C++ application. That's also why return codes are SELECT '<message>'. The <dbname> is first replaced by the actual Database name, before this script is executed: If something goes ...more >>

Does anybody know where i can find "Microsoft Embedded SQL for COBOL Programmer's Reference" or "Microsoft Embedded SQL for COBOL Programmer's Toolkit" ? I have Microsoft COBOL 5.0 and MicroFocus COBOL 3.4 and would like to access SQL databases from COBOL. I've tried eBay, Amazon, Google et...more >>

We've just upgraded a number of databases to SQL Server and I'm having a strange problem with some of my ASP pages. When I retrieve a recordset from a SQL Server table, frequently text or ntext fields appear blank. e.g. Set co = Server.CreateObject("ADODB.Connection") co.Open(myDSN) Set ...more >>

Hello, I am trying to create a ODBC connection to SQL server I got this error. SQL state='01000', SQL server error=10061 I am using windows 2000 and SQL serer is on Windows Server 2003. Any Help? Thanks, Jim. ...more >>

After working in an Access2000 application that is linked to SQL Server tables, you get an error from ODBC, "Login Failed for user 'Admin'." Links were created using SQLServer, via NT authentication....more >>

I keep getting this error - "invalid object name - msmerge_tombstone" when i try to import data into a table. i'm trying to replace the old data with the new. it gives this error when it tries to delete the old. replication used to be enabled on this server but i disabled it and then took it c...more >>

I'm working on an Access app that will have a SQL 2K backend. My setup will install MSDE, and I will set the sa password, etc. which I don't want the end user's to know. My problem is in Relinking the ODBC tables once it is installed in the field. The one item I won't know is the name of the serv...more >>

I have forms, queries,macros, VB6, etc being created in MS Access XP. However, the tables are all created in SQL SErver 2000 Databases systems. In order for my MS Access XP application to work, I linked this Access DB to all the tables in SQL Server 2000 via ODBC connection via DSN. ...more >>

I've got a problem with this function. The Stored procedure that I am calling works correctly but the output parameter does not return RETCODE nRetCode; char buffer[40]; long m_lBufLength = sizeof(buffer); // This is binding the RETURN value nRetCode = ::SQLBindParameter(hstmt, 1, SQL_PA...more >>

Hi all, I have created an application that get Chinese data from SQL Server 2000. I am using ActiveX Data Object 2.5 via ODBC as connection. Most PC work perfectly. However, there is 1 client PC that cannot display Chinese. It always show ???. Can anyone give me some tips? Regards, E...more >>

By calling CDatabase::OpenEx(NULL, CDatabase::forceODBCDialog) you get the ODBC DSN Control panel selection screen thingy to choose from. That screen has File, System and perhaps more tabs on them I want to not go through that selection window, instead only enumerate the System DSNs in my own ap...more >>

Hi, I'm using VS6 C++/MFC/SQL Server 7 SELECT statements return records, which I can get using CRecordSet. However, in Query Analyzer and other SQL Server Query Tools, executing queries result in comments like "12 records updated" And also T-SQL statements like PRINT @myvar will yield ...more >>

Hi there, I need to find out how many database connections are openned by the existing system when connecting to a SQL Server 2000. I tried using PerfMon and I couldn't find any counter to monitor the ODBC connections on the server. Does anybody know how to tackle this one? Thanks, Gilgamesh...more >>

Can someone tell me what the Shared Memory option is used for when one runs the SQL client network utility. Start->Rin Cliconfg There's an option for shared memory protocol. I would like a good technical description of this option. When to use it and when one doesn't need to use it. Many ...more >>

Hi all is it possible to have a linked table in sql 2000 in the tables section of enterprise manager - the same painless way its done in access Many thank IG...more >>

Hi, I want a function to open a database and if a CDBException parameter is provided, it will return any exception in this parameter. BOOL CDBConnectionDlg::OpenDatabase(CDatabase *pDatabase, LPCTSTR lpszDSN, CDBException* dbe) { ASSERT( pDatabase ); try { pDatabase->OpenEx(l...more >>

CDatabase::GetConnect() returns "ODBC; ..." However, CDatabase::OpenEx() may not include "ODBC;". It will fail to connect if it has that prefix. So you can not simply do: { CDatabase a, b; a.OpenEx("..."); // assume this connects fine. // try another connection to the same. ...more >>

I have a Windows 2000 server that needs to connect to a Windows 2000/SQL 2000 box via ODBC but I can't install the latest MDAC. Is it possible to install only the MS SQL 2000 ODBC driver from CD? ... and How do I do it. Thanks...more >>

I am all of a sudden getting this error message on a system, when trying to connect to sql server data: Unable to load SQL Server ODBC driver resource DLL. The application cannot continue. I've reinstalled mdac (2.6 and 2.8), but this has not helped. I need to get this system up and runn...more >>

I am an Access guy and I'm just stepping on eof my solutions up to sqlserver 2000. Linking and seting up referential integrity to other datasources via ODBC in access is easy. SO far in SQL server I've found how to link to a DSN (and now Im aware of DSN-less connections but dont know how to...more >>

H I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem TIA Arrun S...more >>

Hello, I try to make a connection with a SQL Database table from within Microsoft Access and when I display the data in a grid or in a form I get '#deleted' in the feelds. When I make a repport from the same table in the same Access database I get the correct data. There is only one database...more >>

I always get the following error, when someone is trying to to access our live site, the database recoirds are more, how to get away with this problem. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process...more >>

I posted before, but it did not appear. Anyhow, I found the answer -- sort of. The problem is that I have two "identical" machines running identical EXCEL spread sheet. One can do an ADODB connection and the other can not. I could not figure out what was different until I installed SQL ...more >>

Does anyone have any info on how to call a stored procedure with asp classic? Is it possible? I'm running client access v5r2. ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchab...more >>

Hi, I have a customers program on my system - Omin 7 as at http://www.omnis.net/products/omnis7/ - so I can pull the data into an Access Database. I'd like to do this work at my place not theirs! Is there anyway I can set up an ODBC connection so that I can read the files. The .dsn file re...more >>

I'm trying to convert numeric dates on the AS400 to smalldatetime in SQL. I'm able to customize to match format but when I save the tranformation I get the following error. I don't know why they sould let you customize the field if you cant convert. Any ideas? "Error Description: Tranformat...more >>