A client has upgraded an existing application from Access to SQL; in this
case, they are actually using SQL Server Express, which I understand is the
free version of SQL. They installed MS SQL Server Express in their server
system drive and apparently they cannot use it with databases installed in a
separate (data) drive; that part is their problem.
Once they get their drive issue resolved, I need to access the SQL database
from R:Base, preferably using a DSN-less connection.
I have copied their current directory where the database resides to my local
drive for testing purposes, and the following files are present:
Directory of C:\Syntech\Data\
04/08/2011 10:38 AM <DIR> .
04/08/2011 10:38 AM <DIR> ..
03/22/2011 03:08 PM 517
0E3DD96B-93DF-4D95-A3FE-E682DA30DF83.cer
03/28/2011 01:30 PM 517
4B03DE4B-C1DD-4CC7-93D3-D59ED3E0C11A.cer
03/28/2011 01:30 PM 517
77B0E033-6C03-412A-9430-20BBFDDF929C.cer
04/06/2011 04:36 PM 14,876,672 FUELMASTERPLUSSQL.mdf
04/06/2011 04:36 PM 11,599,872 FUELMASTERPLUSSQL_1.LDF
04/06/2011 04:36 PM 4,194,304 master.mdf
04/06/2011 04:36 PM 2,883,584 mastlog.ldf
04/06/2011 04:36 PM 1,245,184 model.mdf
04/06/2011 04:36 PM 524,288 modellog.ldf
04/06/2011 04:36 PM 7,208,960 msdbdata.mdf
04/06/2011 04:36 PM 7,077,888 msdblog.ldf
12/10/2010 01:11 PM 524,288 mssqlsystemresource.ldf
12/10/2010 01:11 PM 40,173,568 mssqlsystemresource.mdf
04/06/2011 04:36 PM 3,342,336 ReportServer$SQLExpress.mdf
04/06/2011 04:27 PM 2,293,760 ReportServer$SQLExpressTempDB.mdf
04/06/2011 04:27 PM 786,432
ReportServer$SQLExpressTempDB_log.LDF
04/06/2011 04:36 PM 786,432 ReportServer$SQLExpress_log.LDF
04/06/2011 04:36 PM 2,097,152 tempdb.mdf
04/06/2011 04:36 PM 524,288 templog.ldf
19 File(s) 100,140,559 bytes
I am very familiar with the procedure to connect to Access databases;
however, my experience with SL is extremely limited and I am probably
missing something simple
The first question is: can I access the SQL database FUELMASTERPLUSSQL.mdf
as stored in my local directory or do I need access to other server files?
The help for SCONNECT for SQL databases is:
SCONNECT ';driver={SQL
Server};server=corpseadb0d;uid=my_user_name;pwd=my_pw;database=JohnDoe;'
I am not sure what the "server" parameter is and how it relates to the local
database. I have tried different parameters with no luck.
I have looked at the "From the Edge" write-ups but I did not find anything
that would help me. I believe that at one point there was a write up, and I
probably have the printout stashed somewhere in my archives, but I am unable
to find it anywhere on line. Any help would be appreciated
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
<mailto:[email protected]> [email protected]
