This is the error message I get:
Error message from server: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified
This is one of the variations of the sattach command
sconnect
'Driver={SQLServer};Server=(phoenix);Database=D:\sqlserver\mssql$begsql\data
\Northwnd;'
also with a space between SQL and Server
sconnect 'Driver={SQL
Server};Server=(phoenix);Database=D:\sqlserver\mssql$begsql\data\Northwnd;'
and with local instead of phoenix
sconnect
'Driver={SQLServer};Server=(local);Database=D:\sqlserver\mssql$begsql\data\N
orthwnd;'
very frustrated,
Bernie
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 24, 2004 4:12 PM
Subject: [RBG7-L] - Re: SqlServer Connection String for DSN-Less Connection
>
> ----- Original Message -----
> From: "Bernard Lis - LTU" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 24, 2004 2:26 PM
> Subject: [RBG7-L] - Re: SqlServer Connection String for DSN-Less
Connection
>
>
> > Mike,
> > I loaded sqlserver on my desktop, same machine as rbase.
> > so for server= What would I put? or just leave that parameter out?
> > Bernie
>
> This example from
>
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer
>
> To connect to SQL Server running on the same computer
>
> oConn.Open "Driver={SQL Server};" & _
> "Server=(local);" & _
> "Database=myDatabaseName;" & _
> "Uid=myUsername;" & _
> "Pwd=myPassword"
>
> would lead you to believe that substituting "PHOENIX" for "(local)" might
work.
> I have no way to test it as I don't have the MSDE installed on anything
here.
>
> It uses almost as much resources as full Sql Server because it mostly is
Full
> Sql Server, but with some throttling on the number of connected users and
> such...Not the greatest for a desktop DB, but OK for testing (but I still
> wouldn't want it "running" other than when I was testing or something.
>
>
> > ----- Original Message -----
> > From: "MikeB" <[EMAIL PROTECTED]>
> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, August 24, 2004 2:17 PM
> > Subject: [RBG7-L] - SqlServer Connection String for DSN-Less Connection
> >
> >
> > > Bernie,
> > >
> > > This worked in RB7:
> > >
> > >
> > >
> > > where Phoenix is my server where SqlServer resides;
> > >
> > > sconnect ';Driver={SQL
> > > Server};Server=PHOENIX;Database=Northwind;Trusted_Connection=yes'
> > > sattach 'customers'
> > > bro * fro customers
> > > sdisconnect ';Driver={SQL
> > > Server};Server=PHOENIX;Database=Northwind;Trusted_Connection=yes'
> > >
> > >
> > > Windows Integrated security must be incorporated on the SqlServer
> > installation,
> > > otherwise you will have to use the
> > > UID=SomeUserID;PWD=SomePasswordThatHasTheAppropriateLoginForSqlServer
> > addition
> > > to the connection string;
> > >
> > >
> >
>
>
