Sample

Discussions specific to Team Developer 5.1.

Sample

Postby Subbulakshmi » Tue Feb 08, 2011 3:19 am

Hi,

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

thanks
Subbu
Subbulakshmi
 
Posts: 132
Joined: Tue Dec 14, 2010 2:24 am

Re: Sample

Postby Jeff Luther » Tue Feb 08, 2011 6:22 pm

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.
Jeff Luther
 

Re: Sample

Postby Subbulakshmi » Tue Feb 08, 2011 10:15 pm

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
 
Posts: 132
Joined: Tue Dec 14, 2010 2:24 am

Re: Sample

Postby Subbulakshmi » Mon Feb 14, 2011 12:12 am

Hi,

Could you please help me by looking into this sample?
Subbulakshmi
 
Posts: 132
Joined: Tue Dec 14, 2010 2:24 am


Return to Team Developer 5.1

Who is online

Users browsing this forum: No registered users and 1 guest

cron