--------------D7EE6C3EE1ED6D1C2CEE86F2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit After reading everyone's advice, and reading another posting on Saturday about remote SQL7 ODBC connection. I figured something out. Unlike Access, where as, you can make a ODBC connection right out the gate, by using the ODBC32 dialog to point to an existing Access DB. I couldn't get the ODBC connection using the Northwind DB or pubs db. For those not familiar with the SQL7 package these are the Microsoft working DB's to help you learn the SQL7 package and syntax. Well, after failing every which way but loose at making the ODBC connection to ColdFusion Server, knowing that the configuration settings were correct in the ODBC32 control panel. A posting about remote SQL7 mentioned that you should not use the "sa" name and password and set permissions. What I did next was to create a new data base with user name and password, set permissions. The ODBC connection to ColdFusion Server worked! I purchased "Inside SQL 7.0 Server" by Soukup and Delaney. This has both Desktop and NT versions 120 day evaluations. It was easy to install and the book really breaks done the complete design, architecture and implementation of SQL7 Server. It is a whole new world in understanding in data base use, flexibility and scalability. Definitely the best move I've made in learning the power of SQL syntax and DBMS. Thanks to everyone for your assistance. Kevin Merker --------------D7EE6C3EE1ED6D1C2CEE86F2 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> After reading everyone's advice, and reading another posting on Saturday about remote SQL7 ODBC connection. I figured something out. Unlike Access, where as, you can make a ODBC connection right out the gate, by using the ODBC32 dialog to point to an existing Access DB. I couldn't get the ODBC connection using the Northwind DB or pubs db. For those not familiar with the SQL7 package these are the Microsoft working DB's to help you learn the SQL7 package and syntax. Well, after failing every which way but loose at making the ODBC connection to ColdFusion Server, knowing that the configuration settings were correct in the ODBC32 control panel. A posting about remote SQL7 mentioned that you <b><u>should not</u> use the "sa" name and password and set permissions.</b> What I did next was to <b><u>create a new data base</u></b> with user name and password, set permissions. The ODBC connection to ColdFusion Server worked! I purchased "Inside SQL 7.0 Server" by Soukup and Delaney. This has both Desktop and NT versions 120 day evaluations. It was easy to install and the book really breaks done the complete design, architecture and implementation of SQL7 Server. <p>It is a whole new world in understanding in data base use, flexibility and scalability. Definitely the best move I've made in learning the power of SQL syntax and DBMS. <p>Thanks to everyone for your assistance. <p>Kevin Merker</html> --------------D7EE6C3EE1ED6D1C2CEE86F2-- ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
