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: [email protected]
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: [email protected]
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: [email protected]
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:
<asidevud>
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: [email protected]
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
