Steema Central

please tell me, is TEECHART not support CONNECTION STRING ?
because when i am trying to use connection string in place of DSN, my page is not generating chart.
is manadatory to use this tool with DSN?

GURUS immediate response will be higly appreciated

Hi ahiml-it,

Yes, this is supported as shown in Tutorial 8 - ADO Database access. You'll find the tutorials at TeeChart's program group. There you'll also find the examples folder which contain several .asp examples some of them connecting to databases.

but sir, when i change only data connectivity code for connection string in place of DSN, my page is not working? why its so?


'Connect to database
dim Conn, qry
set Conn=server.createObject("adodb.connection")
Set RSt = Server.CreateObject("ADODB.RecordSet")
Conn.ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=orders;Data Source=DS"
Conn.Mode = 0 'adModeReadWrite
Conn.open

'Conn.Open "DSN=TeeChart Pro System db"
qry="select OrderNo, ItemTotal from orders"
Rst.Open qry, Conn, adOpenStatic, adLockReadOnly, adCmdText


PLEASE TELL ME WHRE I M DOING MISTAKE

Hi ahiml-it,

You should try doing as in the ADO examples available at the paths below but changing the changing them to your database connection.

C:\Program Files\Steema Software\TeeChart Pro v7 ActiveX Control\Examples\Internet Explorer\examples
C:\Program Files\Steema Software\TeeChart Pro v7 ActiveX Control\Examples\IIS & Asp

Please notice those are default English installation paths.

If the problem persists could you please try if in your project you can retrieve and visualize the data without using TeeChart?

Thanks in advance.