Thank you thank you Mike B! I appreciate your time immensely! Scott Sherer
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Thursday, July 07, 2005 1:14 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: ASP and Oterro Don't use a DSN.. Use a DSN-Less Connection. Here are example(s) of work DSN-Less connection strings (although it is on a local server, not Internet, the mechanics of it are the same)... The multiple connection strings are in an INI file that is read by the application, but you can use the literal text in your application. The newsreader is going to wrap the strings, so you will have to unwrap them yourself. The values to use are after the "ConnectionString=" value. The DBQ values here are Hard Coded, but often I pass in a value and construct that portion of the Connection String at RunTime. [CONNECTION] ;ConnectionString=Provider=MSDASQL.1;DRIVER={R:BASE Database Driver (*.rb1)};DBQ=F:\rbvb\bauerlie\bauerlie;UID=;PWD=; ;ConnectionString=Provider=MSDASQL.1;DRIVER={Oterro 3.0 Database Driver (*.rb1)};DBQ=F:\rbvb\bauerlie\bauerlie;UID=;PWD=; ConnectionString=Provider=MSDASQL.1;DRIVER={Oterro 3.0 Database Driver (*.rb1)};DBQ=\\phoenix\mikd\rbVb\Bauerlie\bauerlie;UID=;PWD=; ;ConnectionString=Provider=MSDASQL.1;DRIVER={R:Base 7.0 Database Driver (*.rb1)};DBQ=F:\rbvb\bauerlie\bauerlie;UID=;PWD=; ;ConnectionString=Provider=MSDASQL.1;DRIVER={Oterro Database Driver (*.rb1)};DBQ=F:\Mikd\rbvb\bauerlie\bauerlie;UID=;PWD=; ----- Original Message ----- From: "Scott Sherer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, July 07, 2005 12:37 PM Subject: [RBG7-L] - ASP and Oterro > We are attempting to get a web-based application written in ASP to talk to > Rbase and are experiencing problems. Essentially, we cannot open a database > connection from the ASP page. > > We have eliminated the basic issues of code errors, database connection and > firewall problems. > > We're running Rbase 7.1 patch 81 and Oterro 3.0. > > Our test code is as follows: > > <% > Dim Conn, myDSN > myDSN="dsn=ourdsn" > Set Conn = Server.CreateObject("ADODB.Connection") > Conn.Open(myDSN) > Response.Write("We have suceessfully connected.") Conn.Close Set Conn = > Nothing %> > > Any advice or help would be greatly appreciated. > > Scott Sherer > --- [This E-mail scanned for viruses by Declude Virus]
