Looking for help with connecting via OLE DB to query a U2 database from SQL Server 2005 as the tool for sql queries and inserting data into a sql database. If anyone can point me to somewhere that I can obtain detailed instructions for how to troubleshoot a connection, I will really appreciate it! Have attempted to connect using the Import/Export and via Linked server. I have the Universe ODBC client installed on the SQL server along with UniOLEDB. Two problems:
Problem #1) Import Wizard: Choose UniOLEDB Provider, test connection succeeds on Data Link Properties Window, but get the following error message when I click "Next" after choosing UniOLEDB as the data source: TITLE: SQL Server Import and Export Wizard ------------------------------ Cannot get string literals from the database connection "Provider=IBM.UniOLEDB.1;Password=;Persist Security Info=True;User ID=lmsodbc;Data Source=LMSODBC". ------------------------------ ADDITIONAL INFORMATION: Object reference not set to an instance of an object. (DTSWizard) ------------------------------ BUTTONS: OK ------------------------------ Problem #2) Would like to set up access to a Universe database via Linked Server (I have never set up a non-sql linked server before). I don't see UniOLEDB on the list of providers. Need help with filling in the Other Data source information in the Linked Server Properties window: Provider, Product Name, Data Source, Provider string, Location, Catalog, and any Security or Server Options. Thanks! ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
