----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: spinachman Message 1 in Discussion Hi all, I am trying to generate a report from acess. In acess i have linked one table from DB2 and two tables from sql server. I have generated a .qry file and these queries works fine when run in MS access. DSN for the both the database is set. When try to run these query files in crsytal report i am getting odbc error, as the password in sql in not saved and its throws a error saying "ODBC ERROR-CONNECTION TO THE SERVER NAME FAILED." The password field is blank so it is not able to connect to the server. Can any one help me as to how to go about solving this issue?. I cannot import these tables to access as these sql tables are refreshed with new data daily. Thanks prakash ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
