Sample

General discussion forum about all databases other than SqlBase.
Subbulakshmi

Sample

Post by Subbulakshmi » 08 Feb 2011, 11:19

Hi,

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

thanks
Subbu

Jeff Luther

Re: Sample

Post by Jeff Luther » 09 Feb 2011, 02:22

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

Re: Sample

Post by Subbulakshmi » 09 Feb 2011, 06:15

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
You do not have the required permissions to view the files attached to this post.

Subbulakshmi

Re: Sample

Post by Subbulakshmi » 14 Feb 2011, 08:12

Hi,

Could you please help me by looking into this sample?

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests