Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 16 16:10:24 CDT 2007
Randall, et. Al.: I finally got some good MS tech support on the phone, guy named...Martin...I think...could barely understand him for the accent, said he was in Belfast. Anyway, guy's a genius with this SQL stuff. Walked me through the download of the manager, got my DNS created, and am in the process of linking the tables from Small Business Accounting 2007. There are about 1000 tables, most prompt for a PK. Should take about two days to link them all. Thanks for the help. I'll have more questions soon. BTW that SQL Server Management Studio Express is terrific. Best to all, 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 1:08 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions 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 -- 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