RE: [U2] UniOLEDB hangs
Hi Brain,
I have setup uci.config and ud_database in Unidata. VSG is working fine,
but when it goes to web asp page, it hangs. I am using the asp example
that provide in Using UNIOLEDB menu. I was able to connect a few time
but not all the time. Can you setup multiply db in ud_database? I am
thinking that I missed something for this ADODB connection test.
DATABASE=cconv
UDTHOME=/usr/ud51
UDTACCT=/datatel/live/collive
TRACE_LEVEL=3
DATABASE=cconvsql
UDTHOME=/usr/ud51
UDTACCT=/datatel/work/cconvsql
TRACE_LEVEL=3
I am testing this on IIS 5.1
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 Brian Leach
Sent: Tuesday, November 28, 2006 10:13 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi
You might want to look at an article entitled "How to Access U2 Data
using
ODBC and OleDB" in the U2UG Knowledge Base (www.mvopen.org/kb). It is a
primer and may help.
Regards,
Brian
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody
> Sent: 28 November 2006 12:40
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UniOLEDB hangs
>
> 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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
<%@ Language=VBScript %>
<% ' VI 6.0 Scripting Object Model Enabled %>
<% if StartPageProcessing() Then Response.End() %>
function do_test()
{
// read form fields
var location1 = Request.Form("location");
var datasource1 = Request.Form("datasource");
var username1 = Request.Form("username");
var password1 = Request.Form("password");
var sql1 = Request.Form("sql");
// write back form fields to response page.
Response.Write("INPUTS:<BR><BR>");
Response.Write("Location:" + location1 + "<BR>");
Response.Write("Data source:" + datasource1 + "<BR>");
Response.Write("Username:" + username1 + "<BR>");
Response.Write("Attempting connection...<BR>");
// create a connection using UniOLEDB Provider
var Conn = Server.CreateObject("ADODB.Connection");
Conn.Provider = "IBM.UniOLEDB.1";
var ConStr = "DATA SOURCE="+datasource1+";LOCATION="+location1+";USER
ID="+username1+";PASSWORD="+password1+";";
//var ConStr = "DATA SOURCE="+datasource1+"LOCATION="+location1+"USER
ID="+username1+"PASSWORD="+password1+";";
Conn.Open(ConStr);
Response.Write("Connect OK<BR>");
Response.Write("Executing SQL...<BR>");
// execute SQL Statement
var RecordsAffected = 0;
var Rs = Conn.Execute(sql1);
// write field names to response page
for(i = 0; i < Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Name);
Response.Write(" ");
}
Response.Write("<BR>");
// write data to response page
while(!Rs.eof)
{
for(i = 0; i < Rs.Fields.Count; ++i)
{
Response.Write(Rs.Fields(i).Value);
Response.Write(" ");
}
Response.Write("<BR>");
Rs.MoveNext();
}
// Close record set
Rs.Close();
// Close connection
Conn.Close();
Response.Write("DisConnect OK<BR>");
}
do_test();
<% ' VI 6.0 Scripting Object Model Enabled %>
<% EndPageProcessing() %>
/*
HTML code below displays a form that collects connection data
from user. When user hits the button, the asp page
"test1_do.asp" is executed to generate a results page from
the query.
*/
// FILE: test1.asp
<%@ Language=VBScript %>
SQL Execute
Location:
Data Source:
User Name:
Password:
SQL:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
Hi You might want to look at an article entitled "How to Access U2 Data using ODBC and OleDB" in the U2UG Knowledge Base (www.mvopen.org/kb). It is a primer and may help. Regards, Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody > Sent: 28 November 2006 12:40 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniOLEDB hangs > > 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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniOLEDB hangs
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/
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/
