Sample

[Subbulakshmi]

Hi,

Could any one help me in proving the code to connect to sql server through oledb?

thanks
Subbu

[Jeff Luther]

Well, the code is to set the SqlUDL TD variable is one way. Here's an example:

Set SqlUDL = "Provider=SQLOLEDB;Password=<password>;Persist Security Info=True;User ID=<user>;Initial Catalog=<database>;Data Source=<server>"

and then call SqlConnect

Another is shown in TD help for this function: SqlCreateSession

I suggest writing a small app. to test this to see how it works.

[Subbulakshmi]

Hi,

I have written a small testcase but it is not working. I have atached the file and error screenshot also. Could you please have a look and advise me?

Thanks
Subbulakshmi

[Subbulakshmi]

Hi,

Could you please help me by looking into this sample?