IS TEECHART not support CONNECTION STRING ?

ahiml-it · Post by **ahiml-it** » Fri Jun 15, 2007 3:24 pm

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

Narcís · Post by **Narcís** » Fri Jun 15, 2007 3:27 pm

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.

ahiml-it · Post by **ahiml-it** » Fri Jun 15, 2007 3:42 pm

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

Narcís · Post by **Narcís** » Mon Jun 18, 2007 8:19 am

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.