I am converting an Access 2000 app to use SQL server instead of access tables. There is a lot of work ahead to get it where I really want it - especially after browsing this newsgroup and doing some research. I will be using SQL pass-through queries to replace the existence of link tables -...more >>

I'm getting strange character groups dropping into one of my database tables, when the user is copy/pasting from Word. They certainly aren't ASCII, and appear to be multiple characters for one. Usually happens when ' or " are used. City of York Council’s Local Plan could be superceded by a...more >>

Since SQL server keeps track of every modification to a table during a transaction, if I change a field value in a single row of a table, where do I look to find the log file that was generated that will tell me what the old value was and what it is now? Also, is there a way to have SQL keep t...more >>

I'm trying to import to SqlServer(2000) from a Sybase ODBC(12) connection. I can use the Sybase connection with appps like MSAcess, and Crystal reports, but I can't get SqlServer to use that same ODBC connection to Sybase. I get "no provider exits for this connection on this computer". Than...more >>

Hi, I have a column in a table defined as Char(1). I'm trying to map it in a call to SQLBindParameter using: sql type = SQL_CHAR native type = SQL_C_CHAR size = 1 However, I'm getting a "string data, right truncation" error. Also, I'm able to map it and insert data to the column as:...more >>

I am trying to find information on the actual values for the fRequest parameter needed for this API Call I have looked in MSDN etc but cannot find the actualuu defs for the actual values Any help? Chris ...more >>

I have set up FileMaker 7 trial and FileMaker Server 7 trial on my Windows 2003 server pc. I have installed DataDirect SequeLink 4.5 ODBC driver. The problem is, when I try to actually create a datasource, in this case on the local machine, I get the following error when I try to test a connec...more >>

I receive numerous deadlocks while processing transactions with more than 2 users in SQLServer 2000 SP3. While these does not happen often, it does happen often enough where it has become an annoyance. The error that the users are getting are very similar or identical to the one below: Micro...more >>

When executing a print statment in a stored procedure that is called from an odbc application. The procedure stops without any furhter information. SQLServer 2000 sp3 -- Jones...more >>

Hi, If I create a table from scratch in EM I can then connect to this with an Access front end, and add / update and delete data as will. If I import an existing Access table and then connect to it in Access I find that whereas I can update and delete existing (ie imported) rows I can't upd...more >>

I am totally new to SQL server. I am moving all of our Access DB's over to an SQL server DB - and am only using Access as the front end interface and development tool. The tables came across no problem and after I relinked all of them to the SQL server DB tables using the ODBC driver, the app ...more >>

I have just imported into SQL server all of my Access 2000 tables. In my front end Access app, I now am using linked tables to access the data in the SQL server db. The speed isn't the greatest. Is there a better connection type I can use in Access - other than ODBC that provides better spe...more >>

Good morning. We are building a SQL Server client in C++ and out client needs to be able to dynamically discover collation information about result set columns and existing table columns. We'd like to be able to map that collation back to an LCID in Win32. Does anyone know the proper properti...more >>

I have a Microsoft Access 2000 with several ODBC linked tables. The back end DB is SQL Server 2000. At the beginning everything was running OK. Apparently randomly, Access returns the following error: "ODBC -- connection to SQL Server failed" when I try to open a linked table that previously wor...more >>

What is the best way/best driver to use to connect to MSSQL Server from FreeBSD 4.x/5.x without using FreeTDS ? I'm having odd/unknown problems with FreeTDS and am looking for an alternative Thanks ...more >>

Hi all, Am basically doing a select star on a collection of tables in Access tables, the data that i select is then taken and put into an SQL server database. Now i am getting the following error, which i believe is related to a timeout, as i can transfer in the region of 3-4000 records bef...more >>

Hello: I have multiple ODBC connections to our SQL Server, and they are mostly working well. I have an issue once in a while with the connection when the DSN is not the DSN used to create the linked table. For example, If the DSN is named the same, but is connecting through IP address vs. Co...more >>

When i execute a Query from an Oracle Linked server i got 99 rows less then the original data. when i run The query in oracle i got 999 rows , when i run in SQL using openquery i got 900 rows. Any idea..? ...more >>

I work on a commercial software product that is a database application. ODBC database connectivity and MFC record set classes are used to access the database. The software supports three types of databases - Oracle, Sybase ASA, and SQL Server. One of our clients has a relatively big SQL Server...more >>

I have a workstation (XP Pro) being used as a test server for a trial version of Microsoft SQL. This test server also houses an EasyPHP setup. Several local workstations have been able to connect to the test server either via the web site server (IP or by name) or through ODBC into the SQL s...more >>

I've got the evaluation edition of SQL server 2000 and i am trying to create a simple databse, for a student project, when i get this error. [Microsoft][ODBC SQL Server Driver]Syntax error or access violation i get the error when trying to parse or execute the following segment of code; C...more >>

Hi all, I need to connect SQL Server 2000 running on a Windows 2000 machine with an Oracle database running on some Sun Solaris box... What are the possibilities?? Thanks, Ivan ...more >>

I am trying to insert records into a SQL database. I have 15000 records in a file on the AS400, but the transfer only inserts 4096 records. The insert works if I use DTS, but DTS is not an option for us. I am running SQL2000 SP2, V5R1M0 on the AS400, Client Access V5R1M0 SI02795, IBM's 32 ...more >>

Hi, I created a simple VB.NET 2003 application through Visual Studio that connects to a MySQL database and loads a table into a Dataset, and then displays that table information in a DataGrid on a form for editing. The table fill works fine, the delete function works fine, but when I try to upd...more >>

I would be very thankful if anybody could help me with this: If there is a date field with a null value it defaults to 1.1.1900 is it possible to change the default to the empty datevalue or ' / / ' Thanks Bjarni Sigurdsson ...more >>

I get the following from a SQL Trace log on our UPS system communicatiiong with a SQL2K DB: ============================================== ShipUps 3a-e2 ENTER SQLExecDirect HSTMT 01D3DEA0 UCHAR * 0x01E9CB90 [ -3] "INSERT INTO tblShipLog (TotalFrei...more >>

Hello, I am on an XP SP1 system and when I use the ODBC Administrator application to establish a new SQL Server DSN the process fails. After launching the ODBC Administrator I push the "Add" button and select "SQL Server" from the list of available drivers. When I then push the "Finish" bu...more >>

Good Day, Windows Server 2003 accessing SQL 2000 on another server in the network: SQL Server is running great! Windows 2003 is running great! However, every day, sometimes twice a day, the connection from ASP and ODBC to the SQL server stops working. The error is: [Microsoft][ODBC Driver...more >>

I found that I can only use name pipe to connect to the sql server. When I use tcpip, it fails to connect. I am sure I have enabled the TCP/IP protocol in SQL server What causes it? sql is using port no.1433 and I have try using dynamically determine port and force it to 1433 in ODBC setting....more >>

I am trying to read the results from a query like select a, b from mytbl where col0 = ? The first time I run SQLExecute, everything works fine, but when I call SQLExecute a second time with a modified input parameter, it returns SQL_ERROR. Below is the code I'm running with the error ch...more >>

Hi i have a windows xp pro, i using odbc to connect to sql 2000 server. i have two connection that work fine. Now when i try to connect i receive a popup message of error. If i try to configure or recreate my odbc i receive the followin errors: impossible make connection sqlstate: '01000' sql...more >>

Hi, Is there any file that shows every transaction log during work on SQL 2000 regards,...more >>

Hello, I'm tring to insert a large data to image fields. It is an Update query of 2 image fields in the same table. The problem occurs when the data length of the second field is more than 400K. I do: SQLPrepare SQLBindParameter (handle,1,SQL_PARAM_INPUT,SQL_C_BINARY,SQL_LONGVARBINARY,...more >>

Hi i have win xp pro Sp1 in SBS domain. When i try to connect with sql server using ODBC i receive the following error SQLState 08001 - SQLState 01000 with sql error 17 and i can't to connect with DB. Until last week my odbc connection work ok, and now if i try to modify or make new connectio r...more >>

Hi all, I am using DAO 3.6 to connect to a SQL Server db on a remote machine. I can open and close the connection, read records, run stored procedures but when I try to add a record I get "object or database is read only" If I connect to the database using ADO I can add records. Here is m...more >>

Hello, I'm getting an error while processing some cubes. "Cannot lock object 'lazy processing token'. Error: Connection to the server is lost." This only occurs while processing certain cubes on the 64-bit version of AS and occurs just after the 'Writing Aggregations and indexes' portion of...more >>