Hi All, Thanks In Advance! I am attempting to insert/update datetime records via ASP to a SQL 2000 Server database. The data type on the field is datetime (not smalldatetime) and the field name is not a reserved word. I am trying to pass the value of either now() or date() and receive the...more >>

Hello , I am having this problem and I don't know the correct way to solve it. I am retrieving the data from a sql statement using a SQLExecDirect statement. Then i am binding the columns to a variable using the SQLBindCol. I need the columns in a char variable so this is how I define the bind...more >>

Hi, we have a SQL 2000 Server with SP3 installed, wich has been INFECTED with Blaster VIRUS. ONCE DESINFECTED we have got the following error in the application event viewer every minute: ---------------------------------------------------------- Source: SQL Server ODBC driver support Typ...more >>

Hi, I'm having troubles with the SQL Server ODBC driver 2000.81.9001.40 dated on July 22 2003. It is incompatible with our custom application developed with Centura SQLWindows/32 Version 1.5.1-PFT2. When running some queries, the error message reported by the driver is Error No: 20035 Erro...more >>

I am able to create a view in SQL Query Analyzer with no problems. When I try to do this in Enterprise Manager, I get the 'Invalid Cursor State' error when I try to save the view. Any ideas?...more >>

Hi, I'm calling a component from an ASP page. The component in turn access the database and stores/retrieves data from it. But I get the following error. Error Type: Microsoft VBScript runtime (0x800A01FB) An exception occurred: 'Update_Pipeline_Request' /MSO/Pipeline/Pipeline.asp, line 1...more >>

I am running into this problem. I support a vendor product where all I do is place the MSI and PTP files on the servers and run them. Then start the website up. I am running into this error. Microsoft OLE DB Provider for ODBC Drivers error '80040e57' I can't look at any of the tables or code be...more >>

Greetings all, This should be an easy task, and Im sure it is, but as many times as I have tried, I cant seem to get this to work properly. We changed ISPs recently from a shared host to a co-located server, and our former host was nice enough to send us a backup of our old SQL2000 database ...more >>

Hello all, I'm getting this error sometimes. Most of the time it works. i have look on MS website and nothing seems to help.. Can anyone help me with this. Thanks...more >>

i have this error when i change from varchar to smallmoney "ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error." please help me......more >>

Hi, I'm using SQL2K and I have an Access database with linked tables (via ODBC) to the SQL Server. For some reason I cannot create or update records any longer. It used to work just fine. I've refreshed the links, checked the connections etc. but all I get is the error 3027 Can't update. Datab...more >>

Does anyone know how to access a COM component from VC++ 7??? Thanks for any help, and sorry if this is an inappropriate place to post this question, but I did not know which user group to post it on. ...more >>

I have a MS Access 2000 front end application accessing a MS SQL 7 database via ODBC. The application calls many stored procedures in the database. I have a new report and new stored procedure as the source data for the report. Some users accessing the report via a Windows 2000 Terminal S...more >>

Hi, I'm running Windows XP Professional and Sql Server 7 and I keep getting errors about losing my connection to the server. This happens frequently in query analyzer and in VB 6 programs. Any help would be appreciated. Thanks Ellie ...more >>

I have come across this numerous times. I will have a query or view that times out at 30 seconds. However, it runs fine when in a procedure. The error is below. I believe it has to do with my ODBC connection settings, but don't know where to go to make the changes? Can anyone help? ===...more >>

This may be a simple question. We recently converted our backend database from Access 97 to MS SQL 2000. I have a huge reporting database (Access 2002) with thousands of queries that I have been using for years when the database was in Access 97. Now I am linking ODBC to the SQL Server. ...more >>

Anyone know how to do a dirty read through a linked server? I've got a linked server to a very busy Informix DB using Informix 3.38 drivers. John TL Lee ...more >>

I keep getting error 8114 when I query on the linked Oracle server. It states it could not be converted to a datetime value in Microsoft=AE SQL ServerT. The DBTYPE_DATE column most likely has a value outside the range supported by the datetime data type (datetime values must be from January 1...more >>

Which is the best way to get data from an Oracle stored procedure that is returning a ref cursor to SQL server. The data returning in the ref cursor is a unoin of rows that will be saved in a table. Can this be done without creating a separate application between the two databases....more >>

Is it possible to configure ODBC driver, that will provide connectivity to another SQL Server instance, if the primary is not available? Thanks a lot...more >>

Hi, I'm having problems to do updates and insert into an IBM DB2 database from SQL Server. Does anyone know if this is possible ? If so, do you have any suggestions on how to make it work? My environment: Windows 2000 server SP2; SQL Server 2000 SP 2; DB2 ver. 7.2 fixpack 8. Both databa...more >>

I need some help any help would be greatly appreciated- the database administrator is out sick and we can no longer log onto the database. We are a small company with two servers & 7 workstations. Svr1 is the primary domain controller, Win2k Adv Svr - Active Dir Svr2 is the database s...more >>

We are considering upgrading our SQL Server from version 6.2 to version 2000. We're running on an NT operating system, and most users connect using ODBC versions 3.6 and 3.7. I'm finding when users are upgraded to ODBC 2000, they are unable to retrieve their info. Rolling back the driv...more >>

We just upgraded from SQL 6.5 to SQL 2000. We also have moved SQL Server to a much beefier machine. Actual data access in our database is much faster, but we've noticed that the speed of the application itself has slowed down some because sp_sproc_columns now seems to take quite a bit longer to...more >>

I installed Cambridge learner's dictionary on a winXP perfersional edition(sp1) and I receive the message "The ODBC Library is locked. ODBC setup will not continue". How can i solve this problem? thanks for your help! -- Posted via http://dbforums.com...more >>

Ok I _want_ to connect to a SQL server (desktop) from a PocketPC 2002 client. 1. Does PocketPC support ODBC? 2. Is a remote connection possible? Any help will do. Thx. J ...more >>

I have a table(sentences) which has two columns: Indexnumber,Sentence.Sentence column contains a lot of English sentences. I want to select all sentences which contain question mark. I use sql: select * from sentences where sentence Like "%?%" But it doesn't work. ...more >>

Hello, I am trying to establish strong encryption for ODBC. What I am trying to do is enable SSL encryption for SQL on a SBS2K server with certificate server. First, I was able to sucessfully create a certificate. The problem that is occuring is when I check the "force protocol encrtption" opti...more >>

I have generated an OleDB provider from MS VC++ 7 ATL templates. I have modified this using Lon Fishers tutorial! (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvc60/htm l/msdn_vc6oledbprov.asp) However when I come to generating a consumer (using MS VC++ 7 ATL templates) ...more >>

I am at my wits end with scheduling a local package I created. I am a self learner so any help is greatly appreciated. 1. I tried to let the job execute at a time when I knew the Oracle data was available. 2. The package completes with no errors when I execute it manually from the Ente...more >>

Recently upgraded a development station from Win2K Pro to WinXP Pro. It has a MSSQL2K Personal Edition running so it can be used for development when not connected to the company domain (with MSSQL2K servers). It is used for VStudio 6.0 and VStudio.Net development. Recently, while not con...more >>

New to SQL server. I have created a database in SQL7 and have created a table in the database ICFPM. Its really basic, just two fields. I have created a new login to the database, and have made the user a member of everything. I set the database up as a system DSN and have tested the connection...more >>

I dropped a table (table B) that was linked from another (table A). Now when I try to delete a row in table A, it throws an error saying the object could not be found. If I recreate table B with the linked field (even if it is empty and a different data type), then I can delete rows from ...more >>