... Your table might be very large and what you might want to do is scroll through the table a block at a time to examine records. This is what the dynamic...
Hi all, I've had trouble compiling DTL on my debian-64 machine. Seems that ODBCINT64 is #defined to nothing in my version of /usr/include/unixodbc_conf.h I...
2650
Corwin Joy
corwinjoy@...
Jan 20, 2012 12:58 pm
... Well, ODBC is supposed to have a type for ODBCINT64. It sounds like a bug in the unixODBC header. We could #define DTL_NO_ODBCINT64 is ODBCINT64 is missing...
... Hello Michael, I just tried your replace_into example with the following table: CREATE TABLE TEST_MERGE ( pk1 BIGINT NOT NULL, pk2...
2652
Corwin Joy
corwinjoy@...
Apr 16, 2012 4:57 pm
On Mon, Apr 16, 2012 at 6:43 AM, wolfgang_haensch < ... IndexedDBViews don't create where clauses. Instead they prefetch data into memory (a std::set or...
Hi, I have a(nother) compilation problem to report. DTL 3.7 doesn't compile out of the box on Fedora (16). I think its due to some false assumptions about what...
Bruce ... Could you try to work through the headers and get a successful compile on Fedora? If you are successful, then we make a release that accommodates...
Hi all, I am a newbie to your very useful library, trying to get it to work. I am using visual studio 2010, and am trying to connect my C++ code to an access...
Thanks a lot, Michael, for your reply and attention. I really appreciate it. So, I have the following comments/follow up questions: 1. I am actually wanting...
Answers inline again ... From: DatabaseTemplateLibrary@yahoogroups.com [mailto:DatabaseTemplateLibrary@yahoogroups.com] On Behalf Of aly300 Sent: Monday, April...
Thanks a lot. For 1, yes, the system/windows recognizes it, and I have been using that a lot through some other applications to connect them to databases....
You obviously then still need to set up the File DSN in your Control Panel and then you can use the file itself to store the DSN info. Whatever name the File...
2662
Corwin Joy
corwinjoy@...
Apr 30, 2012 4:30 pm
One more comment. In ODBC you can also specify a connection string that points to a file. e.g. "Driver={Microsoft Access Driver (*.mdb, ...
... Hi Aly, Re MS Access from Linux, I think the short answer is "not easily". Someone please correct me below if I am wrong as I haven't actually tried to do...
Yes, exactly, that is very similar to what I want to do. I actually write such a connection string in a file (with the extension of dsn). The question now is:...
DTL doesn't currently have a way itself to write out a connection string, but it's easy to add ... You just need to add a new member to the DBConnection class...
2666
Corwin Joy
corwinjoy@...
May 1, 2012 4:34 pm
... I would second what Paul says, in that connecting to Microsoft Access from Linux is likely to be a mess / difficult no matter what program you are using....
Thanks a lot for your comments, Corwin. One question about this comment below: specifying a connection string that points to the file as you showed, how can I...
2668
Corwin Joy
corwinjoy@...
May 1, 2012 7:47 pm
Aly, This is pretty simple. Let's say you want to connect with the dsn given below. Your code would look like this // Connect to the database * string dsn =...
2669
Corwin Joy
corwinjoy@...
Jun 11, 2012 12:15 pm
One more thing. Here is the code for unixODBC for SQLReadFileDSN so you can see how they process a DSN file. ...
Hello everyone, I am not a professional C++ programmer, but I am trying to use the DTL to connect to Access 2010 (32-bit) on a windows 7 (64-bit). I use Visual...
2671
Corwin Joy
corwinjoy@...
Aug 7, 2012 11:55 am
Andy, I'll try to explain what is happening, please see below: ... I think that is correct. You probably want to use the 32 bit ODBC data providers since I...
Hi, I am trying to get the library working under qt. I am stuck on a couple of linker erros. 75 in total. Is there someone with a solution? The fist two...
it looks like you forgot to link to the odbc library, it may be something like adding "-l odbc" to your linker arguments, i can't recall what the win32 lib...
Hi, Â Â Â Â I thought it worth bringing a discussion paper for a ISO standard C++ database interface to your attention. In my view the authors have missed as...
