Unknown token received from SQL Server
I got this error when trying to run a query in SQL server query analyzer. What is the reason? ...
odbc-sql-server-driver
Configuring SQL Native Client ODBC on the client computer?
We have an application where our clients are connecting to a SQL Server 2005 database - via a SQL Native Client ODBC data source. We are having some difficulties with the ODBC connection getting severed during program execution. After questioning a tech support person, he said that he had seen this type of error before, but they fixed th...
sql server 2008: bcp_sendrow, issue: invalid time format
Hi! I'm having a problem "Invalid time format" when I try to use bcp functions(bcp_sendrow/bind etc.) to insert into a table having a datetime column. so as per googled examples, I populated a DBDATETIME structure, for example: if I wanted to populate 3rd august 2009, exactly 8am localtime, I'd populate the structure members like so: d...
ODBC SQL Server driver error
I have a VB6 app that access's a database thru a ODBC Connection. It will run fine for a few hours then I get the following Error. Any Ideas? [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(WrapperWrite()) ...
Error on Save a changed row if the change was in a field of type 'Memo'
Hi there, We have a Access-db with linked (odbc) tables on an sql-server. Some times there is a rare problem with one column of a particular row: no more changes in the field of type memo are possible. Changes in other columns of this particular rows are saved as normal. The error-msg goes something like: annother application has chang...
What is the best driver for mysql to connect?
I think quesiton is clear. I'm programming with C# and using MySQLDriverCS to connect MySQL. But I'm having issues about speed. Which drivers are you using to connect MySQL? MySQLDriverCS is the best solution? Please make some suggestions for me. Thanks in advance. ...
ODBC data transfer to SQL server
How does the ODBC driver transfer data between an application to MSSQL Server 2005? Is it serialized? I'm trying to send data between SQL Server 2005 & MS Dynamics 4.0 but I suspect my data is altered by the ODBC driver in between. ...
Php/ODBC encoding problem
I use ODBC to connect to SQL Server from PHP. In PHP I read some string (nvarchar column) data from SQL Server and then want to insert it to mysql database. When I try to insert such value to mysql database table I get this mysql error: Incorrect string value: '\xB3\xB9ow...' for column 'name' at row 1 For string with all ASCII chara...
Lost connection to MySQL server in Windows XP while adding Data Source - ODBC
Hi, When I am trying to connect to the localhost, there is no problem. But when I am connecting to my server, I am getting this error. [08S01][MySQL][ODBC 5.1 Driver] Lost connection to MySQL server at ‘reading initial communication packet’, system error: 2 Please tell me how to work around this. I have tried with MySQL ODBC Drivers, b...
VB.NET DataSet not working with view with linked SQL Server
I am in DataGrid hell right now but that's another post. Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server. Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with this ugly error message... ERROR [42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server]...
How to connect MS Access to hosted SQL database?
How to create ODBC or DSN file for connection so that Access Linked Tables are pointing to hosted SQL Tables? ...
ODBC: SQL Server 2008 Driver for MS Access
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source Administration page on my Windows XP PC: Server 2008: SQL Server Native Client 10.0 v.2007.100.2531.00 SQL Server v. 2000.85.1132.00 W...