Hi Bill,
I am little confused about how to create another data source. Can you
give me more detail about it? Do we create another data source by using
MS data source application or uni.config configure editor. Where do you
choose shared data source?
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. :-)
Best regards,
Cody Wang
Datatel Programmer Analyst
Ohio Dominican University
1-614-251-4799
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Monday, November 27, 2006 3:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Cody:
See if the following thread helps.
http://www.nabble.com/OLEDB-connection-string-tf1838501.html#a5019034
Bill
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody
Sent: Monday, November 27, 2006 10:43 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniOLEDB hangs
Hi,
I wonder anyone uses UniOLEDB and experience hangs on connection string
part.
Best regards,
Cody Wang
Datatel Programmer Analyst
Ohio Dominican University
1-614-251-4799
-------
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/
