Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-06 : 08:52:38
|
| SenthilVel writes "Hi can anyone help me in figuring out my problem. We have our Sqlserver running on Windows2000 with 512MB ram and IntelP3 Processor, and using th Client VB Application we are connecting the SQLServer using IP based connection string because the server is located in a remote place. Following is the connection code wich i am using to connectobjData.gDBConn.Open "Provider=sqloledb; Data Source=" & strIPServer & "; Network Library=DBMSSOCN; Initial Catalog=" & strDatabase & "; UID=" & strUid & "; pwd=" & strPwdProblem which i am facing are :1. The application takes lot of time to connect and retriving the data ( Even there is no much data)2. Is our application model correct? Right now we are using a client server model where in we are connecting to a Remote Database using IP based Connections.3. Is the Web Application model is the right one for our requirement.4. Suggestions needed on what criteria we must go for a IP based connections. Also when we should/should not go for IP based connections.Suggestions welcome" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-08-06 : 09:24:58
|
quote:
objData.gDBConn.Open "Provider=sqloledb; Data Source=" & strIPServer & "; Network Library=DBMSSOCN; Initial Catalog=" & strDatabase & "; UID=" & strUid & "; pwd=" & strPwd
Why are you using the DBMSSOCN library?quote:
Problem which i am facing are :1. The application takes lot of time to connect and retriving the data ( Even there is no much data)
Explain your reasoning for assuming this is not a network problem.quote:
2. Is our application model correct? Right now we are using a client server model where in we are connecting to a Remote Database using IP based Connections.
How would we know? We have no idea what you're trying to accomplish.quote:
3. Is the Web Application model is the right one for our requirement.
Requirement? What requirement?quote:
Suggestions welcome"
Post just a little more detail next time.Jonathan Boott, MCDBA{0} |
 |
|
|
|
|
|
Performance Tunning