odbc
Seemingly getting wrong connection string from tabledef
Using Ms Access ... I am trying to change the user to which I am connected to a SQL Server Database from Access. The startup form from my Access Application dynamically connects to the tables via an[详细]
2023-03-29 22:04 分类:问答Parameterised Query to Oracle in ADO Crashes Excel
I have set up a parameterised query, using ADO 2.7 inside Excel 2007. The database connection is made via ODBC and every attempt at executing the query results in Excel crashing...and when I say \'cra[详细]
2023-03-28 23:17 分类:问答Linked server provider issue
We have r开发者_如何学Pythonecently changed the database servers, and had to move the linkedserver setup from one server to the other.[详细]
2023-03-28 17:03 分类:问答32 bit application cant find DSN or Drivers on 64 bit Windows Server
I have a 32bit application running on 64bit windows utilising DSN to connect to a MS SQL database. I\'m getting the following error message:[详细]
2023-03-28 15:13 分类:问答ODBC and JET Databases in Linux
How can you setup ODBC on Linux for JET Databases? I\'ve tried with both UNIXOdbc and iODBC but I can\'t seem to get it to work...[详细]
2023-03-28 07:20 分类:问答SQL Server to MySQL data transfer
I am trying to transfer bulk data on a constant and continuous based from a SQL Server database to a MYSQL database. I wanted to use SQL Server\'s SSMS\'s replication but this apparently is only for S[详细]
2023-03-28 02:28 分类:问答How can I portably implement row-wise binding of arbitrary resultsets in ODBC while avoiding alignment issues?
I have a class which takes an SQL query, executes it, then binds every column in the resultset as SQL_C_WCHAR using row-wise binding.[详细]
2023-03-28 01:28 分类:问答Why do my tables not show up if I leave my connection on the default database?
While I was setting up an ODBC connection in Windows 7 via the Administrative Tools, I noticed that if I don\'t check \"change the default database to\" during the setup in the ne开发者_运维技巧xt ste[详细]
2023-03-28 00:53 分类:问答VB6 ADO INSERT of TEXT field into .MDB
My example VB6 program: Dim conn As New connection conn.Open \"Driver={Microsoft Access Driver (*.mdb)};Dbq=\" & App.Path & \"\\adatabase.mdb;\"[详细]
2023-03-27 18:51 分类:问答ODBC issue with SQL-Server date field when migrating from XP32 to Win7 64
I am running an SQL pass-through query in SAS. When I run it on my 32bit WinXP box, the date field in the final SAS table is numeric.[详细]
2023-03-27 17:47 分类:问答