Search results for query: *

Was going to suggest we require customers to have only one workstation with MS Word if the they want to make roll their own, and then using our program just create the bmp on that machine and save the binary, and for for the few who do not have MS Office 2007+ at all, offer a send-in-return...

Thank you for the responses. (Our customers (small townships) generally use anything between Windows 2007 and upward, but mostly W2007). Pdf seems not to work (or I am missing something). When a pdf is inserted directly in CR (or for that matter, WordPad 2007), (as opposed to using binary data...

I have had this problems for several years now, and even reported it once in the Crystal Reports forum (no replies) because I thought it was a CR problem. I use the OLE container in our application so that the user can create/select several documents (using WordPad, MS Word, Open Office, or...

(emphasis mine) Hi OlafDoschke, ADODB does not use an OLE DB Provider to access ODBC data, as you imply above. But it does use an OLEDB layer - as you changed to in your last post - which then branches off to either the OLE DB provider or the ODBC drivers.

I am not discussing the ADODB architecture here, but which SQL Server drivers for a DSN are best to use, and in my case to use with ADODB. Sorry, maybe I should have originally worded it differently, or left the mention about ADO out completely as not to confuse the issue. Thank you. Hi...

This I realize. But the thread isn't about which driver to keep, but about which driver would be best to use. I can use the OLEDB provider for Sql Server, or I can use ODBC with all three drivers mentioned to establish an ADODB connection. So, would you please clarify what you mean here? I...

I have several odbc (32) drivers on my system for sql server and am confused as to which is best to use: SQL Server Drivers which can be selected in ODBC32.exe: 1. SQL Server sqlsrv32.dll version 6.1.7601 from 2010 2. ODBC Driver 11 for Sql Server msodbcsql11.dll version 12.0.2000 from 2014...

Ok, thank you for the information!

How can temporary user #table (created through a ADODB connection using the SQLNCLI11 Provider), be accessed by a different program running on the same machine by the same user? (I already know this can be done with a global temporary ##table). The connections to the MSSQLS instance are...

Thank you. I will check into these things and try to figure out what is best.

All the best for 2016!

gmmastros, Thank you for that, it was just what I was looking for! I connected to the 'master' DB and used: Call oConn.Execute("EXEC sp_detach_db 'W:\Temp\SQL 2014\MyDB1.mdf', 'true';") Call oConn.Execute("EXEC sp_detach_db 'MyDB2', 'true';") Worked perfectly! yelworcm, that is not what I...

I can use oConn.Execute "drop database MyDB" to delete it completely. But in code, how do just disconnect from the sql instance?

I can use AttachDBFileName in an ADO connection in my application to attach a database to a SQL instance. Also in code (VB), how can I detach the mdf again in order to move it to another location or even or delete it completely? Thanks!

Because of a legacy program, and for now until I have the time to implement something else, I need to transfer data from a SQL Server database on a server to a local SQL Express 2014 database temporary table. This was previously being done by importing data from a SQL Server DB to a JET...

Thanks Olaf. 1. Yes, I just tested that 32 bit SQL/64 Bit SQL and 32 bit App and all works fine. 2. Local DB: Yes, I also need to do this transfer of data to local mdf, (or even to a MDB) because of a legacy program which needs to get temporary data into a local database to be further...

Thanks fredericofonseca! So, they could install the 64bit on the server, and the 32bit or 64 bit on the clients systems in order to also store data locally? Can the native client also be used in code to transfer data between the server db and the local db?

We want to allow some of our low budgeted small curstomers to use SQL Server Express or similar with our Visual Studio 32 bit applications. These customers will only have about 1-2 Gb of data, and around 2-5 regular concurent users each with several hundred record writes per day, and maybe 25...

concerning the decimal separators, the Cap project doesn't seem to be local aware

HughLerwill, you were right. I compiled a new exe and it works now. It wasn't the date of the manifest, because it's date was newer than the exe on the system. I tested this newer exe eith the older manifest already on the system, and also with a newer manifest, and it still worked in both...