We are intermittently getting this error on our SQL server. The front end is access and this happens every so often causing the users to have to exit out of access and reconnect. I'm by no means a SQL expert, and our programmer who manages this database isn't sure what it is either, he says it...more >>

Hi All, Strange thing going on here......I have an application that uses 2 ODBC connections, 1 for SQL and 1 for an Access Database. They are configured as System ODBCs that connect to the databases through a mapped drive to the server. Everything works fine on all users except 4 of them....more >>

Hello. I have SQL Server MSDE running Windows 2000. When I start SQL Agent gives me the following error:"Could not start the SQLAgent$SPSQL service on Local Computer. The service did not return an error..." An Can anyone help me? Thanks. -- ticha ---------------------------------...more >>

I have an MS Access 2003 database that uses a SQL Server 2000 database as it's back-end. The database runs well most of the time but if the users dont use the database for a period of time (approx 10 minutes) and return to it then the connection hangs. When they try to perform any action that ...more >>

Services or applications using ActiveX Data Objects (ADO) 2.0 or greater may intermittently return empty recordsets on queries that should be returning valid results. At the time the problem occurs, the same queries successfully return the expected data when run from non-ADO sources, such as fr...more >>

I have a table of address data which I'd like to put into a mailmerge of envelopes in Word 2003. When I select the Query which I've already set up, an error message says "Record 1 contained too few fields". This problem doesn't happen in Excel 2003, and it didn't happen at all before we chang...more >>

Greetings all, I would like help with how to do a one time import of data from Interbase to MsSQL. kindness Abby...more >>

I am working with SQL Server 7 on win2k server. There was a vb6 ado ODBC application written accessing this SQL Server 7 db. Unfortunately, through a series of workstation upgrades, the source code was lost. Recently, the performance of table inserts degraded significantly. I am trying f...more >>

Hi! I need to build a Stored Procedure that make a insert into a another database (Oracle). I have one ODBC to the database Oracle already created. How can I do this? Thanks Albano Alves ...more >>

Will the 32 bit odbc driver available on Windows Clients Operating systems communicate to a 64 bit SQL Server on Itanium? ...more >>

I have users running an Access 97 application to update records in a SQL Server 2000 database, per an odbc linked table. After modifying a record from within the Access application, the linked table shows the updated record in Access; but, sometimes, the change does not propagate to the table i...more >>

Hi, Running Access 2002 frontend, with SQL2000 backend. When I link the tables, 3 tables appear in Access with all fields loaded with #DELETED. The data is fine in SQL. I can *import* them back into Access out of SQL and they are OK, but cannot link. (This data is originally being impo...more >>

Hi,All I created a view in our SQL server database, which in the view I can delete a record according to the cascade delete relationship. Now, we would like to do it in Access database, so I created an ODBC link to our access database, from access database I tried to delete the record as we...more >>

Hello, I have two SQL-servers. With one I can connect through VPN and after the VPN connection is made it is no problem to make an ODBC connection using TCP/IP using windows securtiy. The account info from the VPN automatically gives access to the SQL-database. Of course because that accoun...more >>

I need to create an ASP.Net page that connects to an MS SQL server as its dbase. But the MS SQL server is really connecting to an MS Access db to get the data.How can I mapped the data of the ms access db so that when my ms sql server connects it can get the data and display the data in my ASP...more >>

Hi, I'm trying to test an SP with SQL Query Analyser from my client db an it gives me this error : [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. I'm using Microsoft SQL SE SP4 and i'm new to it. I read on ...more >>

Okay, I've got the raw data table created, and a trigger on it, and record concatenating, but I can't get around the datetime conversion problem. Can you see anything I'm doing wrong on any of these? [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from ch...more >>

I have an accounting system using the sql server 2000 server ..today I have A strange problem which is unavailability of the data base ..in other words when Iam trying to open the Enterprise manager .I will be unable to open the database folders then it hangs and when Iam trying to open the qu...more >>

I am trying to import an Oracle table with CLOB datatype. The ODBC and OLEDB drivers does not provide this functionality. Is there any way to import the CLOB data? Are there any ODBC drivers(preferably free) that can provide this functionality? Thanks in advance. ...more >>

Please help me. Recently I have been getting the following error more and more often: Microsoft OLE DB Provider for ODBC Drivers error '80004005' General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data Sources\"name of dsn" This doesn't occur all the time jsut every now a...more >>

I'm running SQL Server 2000 under Windows 2000 Advanced Server. Authentication is set up as Windows Only. The Administrator account for the server is set up as an SQL user (this is done by default). I'm using the following ASP code to log onto a sample database (for which the Administrator has...more >>

We have a production server that's cpu is throttled, and requests are timing out. After running the get_waitstats sp, OLEDB is at the top of the list in wait type (99%). How do I determine which spid is involved in an oledb wait type? This is a Windows 2000 sp 3 box, running sql 2000. ...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

I have a MSSQL2000 server with a Linked Server to a FoxPro 5.0 database. When I perform the following query, all is well: SELECT * FROM linkedserver.catalog..tablename WHERE fieldname = ' 123456' The query above works okay. However, when I try the following UPDATE query no rows are affecte...more >>

If I select more than 1000 record from my FoxPro 5.0 database using Query Analyzer or Enterprise Manager I get the following message: "Error converting data type DBTYPE_DBDATE to datetime" This is configured as a "Linked Server" Please Help *** Sent via Developersdex http://www.deve...more >>

Hi I am trying to programmatically create a DSN on a target system for SQL Server using SQL Server Authentication. There are documented solutions for using Windows authentication, but the SQL Server authentication evades me. 1. Hard-coding in the registry: Microsoft illustrates this in H...more >>

Hi! We are developing an application that has SQL server as a back end. As a front end we are using an Access 2002 .mdb file in which we have ODBC links to the SQL Server tables. I think it is better to create all front end objects (forms, reports, etc.) in an Access project. I belive this wo...more >>

My app accesses a simple table (generated by a 3rd party tool) that has a 'datetime' column. My app needs to query for all rows in a specific date/time range. The prepare text is something like: SELECT * FROM TABLENAME WHERE COL >= ? AND COL < ? As mentioned above the 'COL' data t...more >>

I have an asp page (w2003 IIS) which grabs a very small amount of data from a table on our sql server (sql2000). Most of the time the page works fine, with no problems. However intermitently it falls over with: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC ...more >>

I have an Access database that was upsized. Access F/E, S2k back. I cannot update tables that I had to create an index for the upsize. All my queries come back with "cannot insert null" into index field. Access calls it Autonumber and we never have to do anything else. I'm gusssing there is...more >>

I am trying to do a ODBC Connection to a Tab delimited file. However it is not parsing the tabs. Any advice? Thanks Here is my connection string: Private ConnectionString As String = "Driver={Microsoft Text Driver (*.txt; *.csv)};DRIVERID=27;Fil=Text;Format=TABDELIMITED;" & _ ...more >>