Ask a Question related to Informix, Design and Development.
-
Doug Baroter #1
Export UniData database to SQL Server 2000 using DTS via ODBC driver failed
Dear all,
I've downloaded, installed, and running UniData 6.0 for Windows
beautifully in the last three hours or so, during which time, I've
also read some docs and practiced UniData data manipulation a bit.
I've set up ODBC datasource correctly and successfully using IBM
UniData ODBC Driver 3.01 and I've used VSG to create some views from
UniData "database", and I've tested the data source, actually selected
and displayed some records from views via the datasource using a
generic SQL client.
I believe I did everything logically and things ran beautifully.
(BTW, you know it's 4:52 AM EST now.) And I'd like to export the
datasource to SQL Server 2000 using DTS package, here's the problem
during the export process, err msg,
error source: Microsoft OLE DB Provider for ODBC drivers
[Microsoft][ODBC Driver Manager] Driver's SQLAlocHandle on
SQL_HANDLE_ENV failed
How to fix it?
Thanks.
Don Li
Maryland
Doug Baroter Guest
-
ODBC driver does not show up in driver list in ODBC data source administrator
Installed an ODBC driver on a Windows Server 2003 machine. A key shows up in the registry under HKEY_LOCAL_MACHINE- seperate listing under... -
SQL Server 2000 JDBC driver??
I know that Microsoft offers a JDBC driver for SQL Server 2000, but its a EXE file. I'm also under the impression that the actual jar file needs... -
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
Hi, I am able to retrieve data from database and then the object name is fine, say SELECT * FROM problemdb, but when I try to use INSERT, I get... -
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I have error handling in my application and I get this error message immediately after the conn.open call to an Oracle db... The only reason I... -
How to export an Informix db to MS SQL Server 2000?
Hi, My client has an Informix SE database on Windows Platform (NT). How do I export such a db to MS SQL Server 2000? I've searched this NG,...



Reply With Quote

