Email me ( mbyerley at byerley dot net ) the actual code (as *.txt) from your ASP file that contains the Connnection String so I can refer to it. You may call me between 4:30 PM and 5:00 PM today ( I will be by my computer and office phone for a brief period then)
260-637-3924 ----- Original Message ----- From: "Scott Sherer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, July 07, 2005 3:09 PM Subject: [RBG7-L] - Re: ASP and Oterro > Hi again Mike, > > What you suggested didn't work. Would you mind us calling you on the phone? > You may call us at (414) 768-8000 x125 (ask for Cathy), or email me your > phone at [EMAIL PROTECTED] and we'll call you. > > Thanks for your assistance, it's very much appreciated! > > 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] >
