[AccessD] SQL Newbie Questions

RANDALL R ANTHONY RRANTHON at sentara.com
Fri Mar 16 15:08:24 CDT 2007


If you have SQL2K, you would have MS SQL Server and under that Enterprise Manager.
If you have SQL2K5, you should have  MS SQL Server 2005, under that,  SQL Server Management Studio or  SQL Server Studio Express.
If you don't have either, get Express here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

A better question maybe, what'cha got?  Default file extensions for SQL is usually .mdf and .ldf.  Your earlier email indicates .db and .lg.   Have you tried just opening the sampleproduct db with Access?  

>>> "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> 3/16/2007 3:35 PM >>>
In the Program list I have Microsoft SQL Server 2005 with a sub menu of
Configuration Tools and a sub-sub menu with SQL Server Configuration
Manager.

But no SQL Servers > SQL Server Group.

Another question:  suppose I get this link going.  Every time I send it to
someone who has Microsoft Small business Accounting will I have a problem
getting them connected?

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Friday, March 16, 2007 12:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

2000, which means you should have a SQL 2K Enterprise Manager icon/program
somewhere.  Open that and drill down through SQL Servers > SQL Server Group
and see what you got.  You have to ID the server instance AND the DB itself.
If HAL9005 is not listed there, you need to register it by right clicking
SQL Server Group and selecting New SQL Server Registration and follow the
prompts.

>>> "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> 
>>> 3/16/2007 2:45 PM >>>
Randall:

SQL Server Service Manager. (whatever that is)

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Friday, March 16, 2007 11:11 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

Do you have SQL2000 or SQL2005?

>>> "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>>> 3/16/2007 2:03 PM >>>
OK.  Found administrative tools in the control panel.  But, same problem.
Can't find the server.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: Friday, March 16, 2007 10:42 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

Rocky,
Did you create your data source using the ODBC administrator under
administrative tools? If so, use the System DSN.  Add or configure your
server, make sure you're connecting with the proper authentication,  ie
Windows NT or using SQL authentication.

>>> "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>>> 3/16/2007 1:32 PM >>>
More:

I changed the server to \\HAL9005\MSMLBIZ because that's what come up when I
hover over the icon in the lower right corner.

Now I get two different errors: 11004 - Connection failed and 6 - Specified
SQL Server not found.

I also was using File Data Source.  Tried it with Machine Data Source with
the same result.  Which one should I be using?

TIA

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, March 16, 2007 10:21 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

Eric:

Thanks for the lead.  My wizard failed (or I failed I guess) with two
errors: Error 2: Connection Failed, and Error 17: SQL Server does not exist
or access denied.  

I'm running locally.  The SQL server icon is in the lower right corner.
It's running.  

Any ideas what I did wrong?

Thanks and regards,

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Thursday, March 15, 2007 10:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Newbie Questions

Create a DSN using SQL server driver and then test and see if the connection
is able to connect to the database file. It looks like the .db file is the
data file and the .lg file is the transaction log file.

You can then use the DSN to link the tables to your Access project or use
ADO to query the database. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Thursday, March 15, 2007 10:11 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] SQL Newbie Questions

Dear List:
 
I have a need to interface an Access app to either or both of Microsoft
Small Business Accounting 2007 and Microsoft Small Business Financials
packages.  Their tech support tells me that they both have SQL back ends.  
 
What I would like to do is push shipping and receiving transactions from the
Access app into the accounting package to trigger invoices and payables, and
extract customer order detail from the accounting system into the Access
app.
 
I have ordered the 60 day trial of SBF with the SDK (which they told me is
mostly a data dictionary, but that's OK).
 
I have the SBA 2007 and in a folder there is a file named
sampleproductcompany.db which I think they said is the database.  There's
also one named sampleproductcompany.lg.
 
 Is this a SQL database file?  Can I connect to this SQL back end and if so
how?
 
MMTIA,
 
Rocky
 


 	
	
--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 3/14/2007
3:38 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007
11:27 AM
 

--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007
11:27 AM
 

--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
--
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007
11:27 AM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007
11:27 AM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007
11:27 AM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list