| || |
Problem in connecting to SQL Server Database
1.created a SQL database say: qa
2.created a ODBC datasource to connect to qa sqldatabase.
3.Created qarun tables in qa sqldatabase by clicking newdatabase->sql connection in Database Maintenance.Schema file was saved successfully.
4. To connect qarun to SQL :
Open the qarun ,in SELECT DATABASE CONNECTION choose via ODBC,it will show the SELECT ODBC DATA SOURCE
5.Assigned new qacenter link database,assigned ODBC datasource name,assigned schema file path
When i click Finish button ,it throws theError message
"The Microsoft Jet database engine cannot find the input table or query 'QR_DTLSYSTEM',Make sure it exists and that its name is spelled correctly."
Note:1. In qa sqldatabase the table QR_DTLSTYSTM with the field values 0,0,0,125,7,24
2. QARun 4.8.0 ,schema ver 125
Thanks in advance
[ 06-30-2003, 11:21 PM: Message edited by: arulselvanmartin ]
Re: Problem in connecting to SQL Server Database
i would like to know about the sql session.
can you give more(with sql session what wonders can we do?). I know WWW session.
thanks in advance