Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CP60

  1. CP60

    Problem with insertable objects (rtf, Word) and the char spacing

    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...
  2. CP60

    Problem with insertable objects (rtf, Word) and the char spacing

    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...
  3. CP60

    Problem with insertable objects (rtf, Word) and the char spacing

    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...
  4. CP60

    Which ODBC driver?

    (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.
  5. CP60

    Which ODBC driver?

    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...
  6. CP60

    Which ODBC driver?

    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...
  7. CP60

    Which ODBC driver?

    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...
  8. CP60

    Temporary user tables, two different connections, same user

    Ok, thank you for the information!
  9. CP60

    Temporary user tables, two different connections, same user

    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...
  10. CP60

    Transfer data between Server and local mdf

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

    Happy Christmas

    All the best for 2016!
  12. CP60

    AttachDBFileName and then detach in code

    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...
  13. CP60

    AttachDBFileName and then detach in code

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

    AttachDBFileName and then detach in code

    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!
  15. CP60

    Transfer data between Server and local mdf

    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...
See more

Part and Inventory Search

Back
Top