Hi Mike,
That is an interesting site.
However, I still am not able to connect.
Here is what I gleamed from that site:
sconnect 'Driver={SQL
Server};Server=(local);Database=D:\sqlserver\mssql$begsql\data\Northwnd;'
but it doesn't address one portion -- fte shows I need dbq= which is
supposed to be the path to the odbc driver - I think.
Confused in Michigan,
Bernie
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, August 23, 2004 8:31 PM
Subject: [RBG7-L] - Re: Connecting to SQL Server
> Bernie,
>
> look at
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
>
>
>
> ----- Original Message -----
> From: "Bernard Lis" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Monday, August 23, 2004 7:25 PM
> Subject: [RBG7-L] - Re: Connecting to SQL Server
>
>
> > for dsn-less connection, how can I get the path to the odbc driver?
> > Does anyone know the name of the driver?
> > SCONNECT ';driver={SQLServer};dbq= ?'
> >
> > ----- Original Message -----
> > From: "A. Razzak Memon" <[EMAIL PROTECTED]>
> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Monday, August 23, 2004 9:09 AM
> > Subject: [RBG7-L] - Re: Connecting to SQL Server
> >
> >
> > >
> > > At 11:22 PM 8/22/2004 -0400, Bernie Lis wrote:
> > >
> > > >We better learn how so we can convert all the sql server
> > > >users to R:Base. Think how many converts we couild get.
> > > >There must be millions of them.
> > >
> > >
> > > Bernie,
> > >
> > > If your object is to convert SQL Server database to R:BASE
> > > 7.x, then you should be able to SCONNECT and SATTACH SQL
> > > Database using either System DSN (based on SQL Server) or
> > > simply DSN-Less connection, while CONNected to R:BASE
> > > database.
> > >
> > > For SCONNECT and SATTACH command, take a look at the
> > > in-line help. (HELP SCONNECT and HELP SATTACH)
> > >
> > > For DSN-Less connection and examples:
> > >
> > > From The Edge: http://www.razzak.com/fte
> > > (Powered by R:WEB Suite)
> > >
> > > Topic: Using DSN-Less Connections in R:BASE 7.1 for Windows
> > >
> > > Search Articles | Topic Header | DSN | Search ...
> > >
> > > Hope that helps!
> > >
> > > Very Best R:egards,
> > >
> > > Razzak.
> > >
> > > P.S.
> > > You may also want to take a look at Bill Eyring's
> > > presentation and notes on the May 2004 Conference CD.
> > >
> > >
> >
>
>
