|
-
Jun 20th, 2002, 12:53 AM
#1
Thread Starter
Fanatic Member
Database Connection
Hi!!!
I have 2 sites
i put my database on one site www.onesite.com
while the asp pages are on second site www.2nd site.com
now i want to connect asp pages to database from one site to 2nd site.
can any one how can i do it..???
-
Jun 20th, 2002, 05:14 AM
#2
Hyperactive Member
Hi shahid!
'I have provided the connection string for MS-SQL server.
Code:
Provider="SQLOLEDB;Network Library=DBMSSOCN;Data Source=11.111.111.1,1433;Initial Catalog=myDbname;User Id=sa;Password=xxx;"
PS:
IP address of the DB server: 11.111.111.1
TCP port to connect=1433
DBMSSOCN - instructs the system to use TCP/IP connection
Hope this helps you!
Last edited by buddu; Jun 20th, 2002 at 05:17 AM.
prasad
-
Jun 21st, 2002, 01:20 AM
#3
Thread Starter
Fanatic Member
i think this code working with SQL SERVER.
but i use MS Access file..
i hope u pass ur comments for it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|