Bernie,
Correct Syntax (using DSN-Less Connection with R:BASE 7.1 for Windows):
SCONNECT ';driver={SQLServer};server=corpseadb0d;uid=my_user_name;pwd=my_pw;database=JohnDoe;'
***** Notice the following *****
01. Use the database QUOTE character when enclosing the SCONNECT statement.
What is your database QUOTE setting?
SHOW CHAR
Assuming you are using the single quote, then:
02. Start with '; (that is single quote and semi-colon)
03. Include the server name accordingly (;server=)
04. Include full path of database (;database=)
05. End with ;' (that is semi-colon and single quote)
Hope that helps!
Very Best R:egards,
Razzak.
At 10:01 PM 8/23/2004 -0400, you wrote:
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,
