If you have the linked server setup then use the openquery command. SELECT * FROM OPENQUERY (UniDataServer, SELECT * FROM vsgOrderView WHERE OrderID =''2921479''')
I've found that when doing the setup if you click test it kind of hoses up the connection. Try doing it without checking it and just see if it works. But the openquery is usually the fastest and easiest way to get data. I just make a view containing the select I want. But don't ask about writing things back. I don't do that. Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victoria G. Carson Sent: Thursday, November 08, 2007 9:23 AM To: [email protected] Subject: [U2] Need detailed instrutions for querying from SQL Server 2005 Management Studio 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
