Dan Waters
dwaters at usinternet.com
Fri Oct 9 13:23:34 CDT 2009
Thanks Jim - I had forgotten about UDL. I connected first time with UDL, but Power Architect apparently uses some kind of JAVA connection method. I'll have to get help from the folks who made this program. Dan -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, October 09, 2009 12:21 PM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Export from SQL to Access Hi Dan: It sounds, from your description, that everything is local (on your PC), running (SQL Express is running). What I traditional do is: 1. Go to my desktop, right-mouse-click and create a new text file. 2. Rename the extension from txt to udl. 3. Then open the now new udl (ODBC) connection file and create a new connection and keep testing (test Connnection button) until a connection is made. 4. After the connection has been made I again rename the file exstention from udl to txt, open the newly created text file and then copy ands paste the connection string displayed in my application. If you are having some issues it may be because your SQL Express port (1433) is either been renumbered or blocked by your firewall. For further comments see the following link: http://www.teratrax.com/articles/connecting_sql_server_express.html HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, October 09, 2009 9:56 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Export from SQL to Access Hi Jim, I've tried using the Database Connection Manager in Power Architect with these the parameters: Connection Name: Express DB Type: SQL Server 2005 Host Name: danwaters\sqlexpress Port: 1433 JDBC URL: jdbc:sqlserver://danwaters\sqlexpress:1433 I also enabled TCP/IP for SQL Server. The first line of the full error message is: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect How could I use the ODBC Data Source manager to make this connection? Thanks! Dan -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, October 09, 2009 11:36 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Export from SQL to Access Hi Dan: Have you tried your ODBC data source manager yet? Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, October 08, 2009 1:53 PM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Export from SQL to Access Hi Rob, I tried to get this to connect to sqlexpress on my PC, but after an hour it's still not working. I'll try again later. Thanks! -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert Stewart Sent: Thursday, October 08, 2009 1:45 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Export from SQL to Access http://www.sqlpower.ca/page/download?fileName=http://power-architect.googlec ode.com/files/Architect-Setup-Windows-jdbc-0.9.13.exe may work At 12:00 PM 10/8/2009, you wrote: >Date: Thu, 8 Oct 2009 07:08:10 -0500 >From: "Dan Waters" <dwaters at usinternet.com> >Subject: [dba-SQLServer] Export from SQL to Access - Include Table > Relationships? >To: "'Discussion concerning MS SQL Server'" > <dba-sqlserver at databaseadvisors.com> >Message-ID: <FD5D6F4624784A549D925CA4004DB36D at danwaters> >Content-Type: text/plain; charset="us-ascii" > >Hello Everyone! > >I found out how to export data tables from SQL to Access using SSIS. >However, the table relationships did not come across. > >Is there a method in SQL or Access to quickly copy tables from SQL to Access >and include the table relationships? > >Thanks! >Dan _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com