Tag Info

New answers tagged

0

The answer will depend upon what tools you have available. What database system are you trying to get the data into? Oracle? Sql server? Windows machine or unix box? One alternative could be install software on a 3rd machine. (your PC?) Extract the data and convert it into a suitable format to import. Another option could be to export the data to a .csv ...


0

Based on the current release driver release compatibility matrix, found here, if you want to support Netezza NPS v6.0, v6.1, and v7.2 with the same ODBC driver, you should pick the most recent patch of the 7.1 ODBC driver. If you don't need to have the same driver support all three server levels, then you would likely be better off going with the most ...


0

ODBC as just an interface between applications and drivers. It is impossible to create an ODBC connection without using some installed driver.


0

[Not really an answer as I'm just stating the obvious but I don't have enough rep to comment.] The four driver files are the ODBC driver, the JDBC driver, and the 32 and 64-bit OLEDB drivers. The ODBC driver is of course the correct one but there's a small check box in one of the installer dialogs which allows you to choose 32-bit and/or 64-bit. Did you ...


1

Apparently this just boils down to SSIS treating any varchar larger than 128 as NTEXT. Not sure why. I can, however, go into the advanced properties of the ODBC source and change the types back to something like DT_WSTR. Which seems to work for the most part. However, I did determine that a few of the tables I'm dealing with actually are carrying upwards of ...


1

IIRC, Access uses either a machine DSN or a file DSN. I only have Access 2016 installed but I don't think this has changed much. There should be an External Data tab in the ribbon, click on ODBC Database. This shows you two tabs: File Data Source and Machine Data Source. This image shows the MS Access Database source but I generally see folks create one ...


0

I have found a driver that I can install on a PC that does not have SQL Server installed on it and it makes Excel's data connections connect to SQL Server with cell linked parameters that are dates. The install can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=36434 You then need to change the driver in your connection string to ...



Top 50 recent answers are included