Always a pleasure ;)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Mark Warner
Sent: Saturday, January 31, 2004 10:51 AM
To: [EMAIL PROTECTED]
Subject: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server
Chuck,
That did the trick. Thanks so very much. I greatly appreciate the help.
Mark
Date: Fri, 30 Jan 2004 08:57:23 -0500
From: "Chuck Mongiovi" <[EMAIL PROTECTED]>
Subject: RE: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server
2000
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"
I've been working on this recently and had a similar problem .. You need to:
1) setup a SYSTEM DSN on the Win2K side, not a USER DSN
2) setup the appropriate clause in the uvodbc.config
After that, try doing a CONNECT and a CONNECT {DSN} from TCL and do you SQL
statements manually to test the connection .. Then write the BCI
HTH / chuck
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of HENDERSON MICHAEL MR
Sent: Thursday, January 29, 2004 10:49 PM
To: 'U2 Users Discussion List'
Subject: UNCLASSIFIED RE: UniVerse 9.5.1/NT talking to SQL/Server 2000
Mark,
1) 9.5.1 is really old! All this stuff is much easier / better / runs
faster in current releases
2) Are you trying to access SQL server from UniVerse, or UniVerse from SQL
Server?
* UV from SQL server is fairly easy, all the information is in the
ODBC manual, at least from 9.6 onwards
* SQL Server from UV is much harder, you have to use the BCI (UniVerse
Basic SQL Client Interface)
From what you said, it looks like this is what you're trying to do
Look in the BCI manual for starters, also the CONNECT program in the
BP file in the UV account
You'll have to write some UniBasic code to use BCI
HTH
Mike
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Mark Warner
Sent: Friday, 30 January 2004 4:23 p.m.
To: [EMAIL PROTECTED]
Subject: Univerase 9.5.1/NT talking to Sql/Server 2000
I've search the postings on the list, and from what I've read this
should be fairly simple, but for some reason I just can't seem to get this
to work. I've set up the uvodbc.config entry and have set up a odbc in the
control panel, but when I try and use the CONNECT verb to get connected to
the sql/server side, I get the following message:
SQLConnect error: Status = -1 SQLState = 08003 Natcode = 0
[ODBC] [Microsoft][ODBC Driver Manager] Connection not open
What am I missing here?
Any help with this would be greatly appreciated....
Mark
_______________________________________________
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
_______________________________________________
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
