Hello, I have taken on a project where I'm wondering if I'm in a little over my head. Using SQL Mail I need to send out e-mails every hour for orders that have shipped. There are two databases. One is SQL Server and the other is only accessible via ODBC (I'm not even sure what type of datab...more >>

Hi at all, I have a database on a sqlserver 7.0. I access to it via odbc api. So i need t change the name od a table. Is there a way via SQL* api functions to change the name of a table? thnaks roberto ...more >>

I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about 25-50). This allows each user to have their own set of selections. The selections table has three f...more >>

Hi, I just did a test, this code returns 1 on a windows2003 Server system, and my import works fine, however if I run this same code on a WinXP, Pro or XP Media it then returns 1 and the import does NOT work... Please any suggestions would be creatly appreciated.. where should I start ...more >>

I have a MFC VC7.1++ program using VS2003, and also using the MSDE2000 for some reason my import is now failing and I cannot figure out why, before today this first statement use to successfully process. The return value of retcode now is 0, it use to be retcode = 1 I have looked up the d...more >>

I have an Access 2000 MDB with ODBC linked tables to a SQL Server 7 back end. I currently have a selections table in the front end file which the users use to make selections of records. The table has two fields -- primary key (which matches primary key of main, SQL Server table), and a boolea...more >>

I am just starting in the SQL world, so I know this will probably be extremely easy questions to answer. 1. On a machine that doesn't have SQL Server listed in the ODBC, how do I install that driver? By installing MDAC? 2. I went to a Win98 ver A machine and it didn't have an ODBC short...more >>

Hello I have 2 networks network A and B both networks are running SBS 2003. On Network A I have installed SQL 2005 On Network B I have Yardi SQL Both the networks are being controlled by SBS 2003. What I would like to do is have the SQL 2005 server communitcate with Yardi SQL Server. ...more >>

HI, i have an access MDB linked by ODBC to SQL2k. I get a strange behaviour when i do an INSERT INTO to a local Mdb table from "LEFT OUTER JOINED" SQL tables. If the related table hasn't related record to the first table, it get an Error 3167. This behaviour is not present with MDB tables...more >>

We just setup a new Windows 2003 server and we can't use System DSNs. If we setup user DSNs they work just fine, but everytime we try to use a System DSN it can't be found. Does anyone have any suggestions? Josh ...more >>

Our company only allow the use of Merant 3.60 32-bit Sybase ODBC Driver (Version) for connection to Sybase Sybase 12.5.3 DB on Sun OS 5.3) I have a stored procedure on Sybase 12.5 ASE which a) Select 'dummy' b) Select lots of stuff using joins and filters into tempDB.tempTable using dirt...more >>

I have an SQL Server database that uses 'datetime' fields. I want to write to these with SQLBindParameter(). What SQL type should I specify? If I use SQL_TYPE_TIMESTAMP I get errors from SQLExecute() and SQLGetDiagRec() states that there is an overflow. Many thanks. ...more >>

I'm new to SQL and am in the process of migrating to a SQL backend for my Access 2000 front end. I'm going the ODBC route to get my databases up and running quickly and then move to an Access Project but I'm haveing problems understanding the relinking issue. Is there a white paper I've missed...more >>

Hi, I have the ODBC tracing enabled on my development machine using the "default" tracing DLL. I thought it was just our applications causing this, but I'm also seeing this when using isqlw (SQL Query Analyzer). Is it an issue? The app. seems to have no issues. I know it is indicating ...more >>

I’ve run into an issue with a user trying to make an ODBC connection to an SQL Server database and I have no clue as to why this one thing happens (or more precisely doesn’t happen). She logs on to her PC with her Id. She can make a connection to a database on one server with no problem. H...more >>

Is there any place where I could find the best way to query a sql table or access table via ODBC through either a web interface or a transact SQL query that would post the results to a http page record by record. (open a web browser window for each record) that way if we had to we could have...more >>

Hi All, I have an C++ application that uses ODBC to access SQL server. The application invokes the SQLAllocHandle() function to: 1. Get an Environment handle (Created only once) SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env) 2. Get Connection handle(s) by passing Environment hand...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Timeout expired Hi all, I am getting this error while trying to insert a record into the database table. We are using SQL SERVER 2000/ODBC/ASP combination. I would really appreciate if somebody...more >>

Hello, A little background... I have a cube that automatically refreshes every 10 minutes and pulls it's data from a view ('ViewA') in sql server 2000. The cube takes around a minute and a half to completely refresh. During this time, in sql server, one of my other views ('ViewC') starts...more >>

Moved a database over to a new SQL server. That database had a couple of stored procedures that call two different databases. I linked the servers, but I know that the tables that show up correspond to the default database on the security account i have setup to connect to the server. Is there a...more >>

10/17/2005 Hi Sue, The problem is occuring when I am attempting to run a query from Query Analyzer using the Client side software and against only one of the databases. John K ...more >>

I have a very puzzling situation with a database. It's an Access 2000 mdb with a SQL 7 back end, with forms bound using ODBC linked tables. At our remote location (accessed via a T1 line) the time it took to go to a record was very slow. The go to mechanism was a box that the user typed the in...more >>

I am using SQL 7 with an MS Access 2000 MDB front end, using bound forms with ODBC linked tables. In one form, the user needs to be able to check a box to select one or more records. This is accomplished with a local table containing two fields: the primary key value of the SQL table and a boo...more >>

I am requesting help with the following SQL Server problem: When attempting to run a simple 'Select * from tablename' in Query Analyzer I receive back only a small portion of the total records in the table and the following error messages are displayed in the 'messages' tab: [Microsoft] [ODB...more >>

Is there a way to retrieve a list of all database triggers using the ODBC API? I'm looking for something like SQLProcedures that can retrieve a list of all database procedures. Are triggers not supported by the ODBC catalog functions? Why not?? I CANNOT use any database specific software s...more >>

I hope this is the correct forum for this question. I'm posting here because I suspect an ODBC or OLE DB setting is at the root of this problem. I have a very long string value, 2512 characters, that I need to store in the database to retrieve later. No matter what I try, however, it appear...more >>

Hi, I really appreciate if someone could help me with this problem. Actually i m trying to create a crystal report using stored procedure which uses temp table. First time when i created the report using this stored procedure it worked and it still works. But when i tried to create anoth...more >>

How do I update or delete a record with this floating point error in X field? And, what the heck causes it? Thanks! Chris ...more >>

Hi, I am having problem while restoring database to another SQL Server. I receives below given message. My both SQL Servers are 7.0. MESSAGE SQL DMO (ODBC SQL Stae 42000) The database you are attmpting to restore was backup under a different unicode Locale ID (1033) or Unicode Compar...more >>

i have an access 2000 db in which i dynamically relink the tables from sqlserver 2000 depending on the user - some users having read only permissions, others read/write etc. however access 2000 DOES NOT relink correctly and after looking in msysobjects in access, have found that it seems to ca...more >>

Hi, I'm having trouble linking a simple example using the bcp functions... The error: ************************************************ test.obj : error LNK2001: unresolved external symbol _bcp_init@20 ************************************************ Environment: Windows 2000, SQL Server 20...more >>

To dynamically set the length of a variable (Code in C) to store data, i use the ODBC API function SQLDescribeCol. When a smalldatetime column type from SQLServer is treat by SQLDescribeCol, the COLSIZE return by the function is 16 when YYYY-MM-DD HH:MM:SS contain 19 characters. This case overlo...more >>

Server is quad processor with 3 gig of RAM of whcih 2 gig is allocated to SQL. Last weekend we upgraded the SQL from SP2 to SP4, since then the ODBC queries trhey run via MSQUERY appear to be really hitting the CPU and sqlserver.exe is consuming up to 90% of the CPU. It is looking very much lik...more >>

On an XP PRo SP2 machine connecting to both a local and/or network SQL Server 2000 machine (unknown SP at this time), only ONE machine is getting this error "Provider cannot be found. It may not be properly installed.". While the answer looks simple (reinstall), this does not solve the problem...more >>

Hi All, I’m developing a simple program which will connect to a SQL Server 2000, but when I install the SQL Server I got a message inform me that I cannot complete, once I check the ODBC drivers I cannot find any of them. I’m using a Win XP home edition, although I’ve tried...more >>