----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 24, 2004 7:59 PM
Subject: [RBG7-L] - Re: SqlServer Connection String for DSN-Less Connection
> 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;'
DO NOT put the pathname to the DB for "Database". Only the actual Name of the
Database.
For Server, Put either the "(local)" as in your last example, or the Name of
your computer.
When the name of the computer is used, there is no parentheses around the name,
not as you have shown above where you have left the name of the Server on my
network "Phoenix".
Sorry, but that's all I can come up with lacking the same installation as you
are using...
> 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;
> > > >
> > > >
> > >
> >
> >
>
