RE: [U2] OLEDB connection string
Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OLEDB connection string
In the connection string, what is the Data Source? Is that the server that Universe resides on? What is the Location? Is that the account name? Is it the path to the account? No matter what values I put in these fields, I cannot get it to connect. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Saturday, June 24, 2006 3:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OLEDB connection string
Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin > Network Service > UDTelnet Server > Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Monday, June 26, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string In the connection string, what is the Data Source? Is that the server that Universe resides on? What is the Location? Is that the account name? Is it the path to the account? No matter what values I put in these fields, I cannot get it to connect. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Saturday, June 24, 2006 3:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OLEDB connection string
Very helpful. Thanks a lot Bill! Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Monday, June 26, 2006 6:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin > Network Service > UDTelnet Server > Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Monday, June 26, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string In the connection string, what is the Data Source? Is that the server that Universe resides on? What is the Location? Is that the account name? Is it the path to the account? No matter what values I put in these fields, I cannot get it to connect. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Saturday, June 24, 2006 3:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
