I am using an SQLite ODBC Driver (from here http://www.ch-werner.de/sqliteodbc/) with my VB6 application. Everything works fine, as far as retrieving and saving data, however, if I try to get the list of table columns via the following command: pragma table_info (myTableName) The ADO call fails with 2 errors (found in Connection.Erro...
I'm using the MFC class CDatabase. To establish a connection to SQL Server, I'm calling OpenEx() with a connection string. My problem is that the object seems unable to interpret the DSN part of the string. The connection string looks like this: ODBC;DSN=mySystemDSN;UID=myUsername;WSID=myMachineName;DATABASE=myDatabaseName;Trusted_C...
I have an xls with a pivot table using a proc to populate it. I deleted the data connection in 'admin tools - odbc - file DSN' and it still works, how is that possible? Does that mean that the recipent doesn't have to have the file DSN present in order to see data in the pivot table? ...
I want to connect to a sql server 2005/db with ODBC through ruby using windows authentication. I have the gems dbi-0.4.1 and dbd-odbc-0.2.4 installed. What do I need to do for a connection string? So far I haven't been able to get it to work. DBI.connect("DBI:ODBC:Data Source=#{server};Integrated Security=SSPI;Initial Catalog=#{db}") ...
My client is using Access as a front end to a SQL Server database. They recently started getting ODBC - 3146 errors from time to time when running some reports. From what I can tell, this is just a generic ODBC call failed error. I've tried sticking some error handling in the VB script that is launching the reports, but I am not havin...
I have tried everything.but im not able to insert updat and delete the excel file..im able to connect the excel sheet.the connection also seems to be opened...here s my connection string: Dim sConnectionString As String Const kunal = "C:\" sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Sou...
I've got a seemingly unique issue on just one computer in the company. (had to be my boss's) I've got a program from borland C++ that usese a TSQLConnection. It connects to a local firebird server 2.1.1.17910 running as an application. The other computers work fine. it will ABSOLUTELY NOT connect on this one lappy (local server) for ANY...
I'm trying to set up an ODBC client driver for Progress 10.1b. I was able to install the client software that is required, but there is apparently also an ODBC.reg script file that needs to be run to correctly set up the registry in order for me to use the ODBC drivers. Can anyone point me to where I would find this script? Or tell ...
I am trying to do ODBC import with DSN-Less connection(using text driver). Is there any way to tell SQLDriverConnect to set COLNAMEHEADER=yes/no? OR I need to use schema.ini to do it? Actually i don't want to create schema.ini manually, Can I use SQLConfigDataSource for dsn less connection? I haven't found any docs regarding this. Tha...
Given a User DSN how do I create an ODBC connection to that data source in .Net 3.5? ...
Hi, I am having a lot of trouble using .dbf files. I have an application written in C# that reads from .DBF files and then exports them to another database. I've tried using the Microsoft dBase driver but it's not reading all of the .DBF files that I need to, meaning that I can retrieve data from only two of the five .DBF files, Visual ...
How to invoke configure dialog for a File DSN from C++ program? I can do it for System/user DSN using SQLConfigDataSource. Thanks in advance, Manoj ...
The default base address for an .exe built in Visual Studio is 0x00400000. The default base address for d3dx9_30.dll and odbcint.dll (which both live in %windir%\system32) is also 0x00400000. So by default, exes that link to either of these dlls will have a runtime address collision. The OS automatically relocates the dll to a differe...
I have a .Net service that has a list of strings containing ODBC connections and I use these in a loop to check multiple databases for tasks to process (eg. polling). However if i change where an ODBC connection points to..by changing its default database for some reason, even though i'm only storing the string name of the ODBC connecti...
What is a good pywin32 odbc connector documentation and tutorial on the web? ...
What library should I use to connect to odbc from python on windows? Is there a good alternative for pywin32 when it comes to odbc? What about pyodbc? http://code.google.com/p/pyodbc/ Any others? Which one is good documented, robust, actively maintained, what are you guys using? ...
I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want to use an dnsless connection, so I grab my connection string from www.connectionstrings.com. Ideally I won't have to setup a DNS entry or an Oracle TNS entry, and I may be mistaken, but I thought the above would do that for me. ...
I found a great C++/ODBC example here... The project I downloaded builds great and everything works. However, when I copy the .cpp and .h files into another project, I seem to have a linking problem. The SQLConnect function in sql.h is the one I want. When I right-click this function in the easyodbc.h file in the project I downloaded...
Has anyone got a ODBC data source setup for FileMaker Pro 10 on Windows? The documentation that ships with FileMaker Pro 10 does not make sense as it is saying to click on a set-up file that does not exist. None of the forums are providing an answer either. ...
I have a large dataset, say 1,000,000,000 rows, that lives on a server. I need a user to be able to consume (i.e. "run queries upon") that data seamlessly, over the web, from within Access and/or Excel. Additionally, I need to filter the data on the server-side according to the user connected to it. My current approach is to create a we...