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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Linking a SQL Server 7 DB to an AS400 using OLE DB or ODBC
We tried using the OLEDB provider from Client Access Express, but without luck. Instead, I'm using the Microsoft OLE DB provider for ODBC Drivers and I have an ODBC DSN setup for Client Access ODBC. The only thing needed was the Provider Name and the Data Source Name - the client access ODBC...- acaswell
- Post #2
- Forum: Microsoft SQL Server: Programming
-
DTS and AS/400
Perhaps it didn't in the past, but DB2 does now support NULL values, if the field is described in the DDS with the ALWNULL keyword. To specify an AS400 DB2 file, try using the syntax LIBRARY/FILENAME instead of LIBRARY.FILENAME. I don't know how your HIT software works, but in SQL Server using...- acaswell
- Post #4
- Forum: Microsoft SQL Server: Programming
