----- 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; > > > > >
