Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 16 14:42:08 CDT 2007
Eric: I disabled my firewall but no soap. So I think Sygate was not blocking. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Friday, March 16, 2007 12:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions Check to make sure that the firewall is not blocking port 1433. No reference to ms-sql-s either on local address column? -----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 11:53 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions Eric: Lots of lines but no reference to port 1433. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Friday, March 16, 2007 11:43 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions Furthermore...a quick test to see if SQL server is listening on port 1433 is to go to the command prompt on that machine and type netstat -A (capital A not small a) and then press enter. You should get something like this... Active Connections Proto Local Address Foreign Address State TCP MACHINENAME:ms-sql-s MACHINENAME:0 LISTENING Or Proto Local Address Foreign Address State TCP MACHINENAME:1433 MACHINENAME:0 LISTENING [rest of the data snipped to protect the innocent] ;) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Friday, March 16, 2007 11:30 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions Rocky, If the MS SQL server service is running the machine name is usually the server instance. In this case it would be HAL9005 as per your email. Even if SQL server was running it might not even be listening on port 1433. You will need to configure that with SQL client configuration tool. Eric -----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 11:04 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Newbie Questions 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 -- 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 -- 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 -- 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