web.config file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rafael Chemtob - 01 Sep 2005 21:59 GMT

hi
i have a web.config file that specifies the connection string for my
database. the database server on the ISP is using a different port than
1433. how do i specify in the connection string to use a specific port
number?
i tried the <ip address>:<port number> and that didn't work.
any ideas?
thanks

Reply to this Message

Scott M. - 01 Sep 2005 22:53 GMT

Well, you didn't specify what kind of database you are connecting to, but
here is a sample connection string to SQL Server. You can see where the
port number is and change it to what you need.

"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is
the port to use (1433 is the default))

> hi
> i have a web.config file that specifies the connection string for my
[quoted text clipped - 4 lines]
> any ideas?
> thanks

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...