Error in connecting to database.
-
sorry i dont get any seperate section for VB i have a problem related to vb. i have developed an application thru vb and sql-server. when i m using it frm my pc it works fine but frm client pc it does not connect to database. error on this line.... conn.open() on client pc sql-server client utility is installed wht to do.. i m very much confused reply ASAP.. Ajay
-
sorry i dont get any seperate section for VB i have a problem related to vb. i have developed an application thru vb and sql-server. when i m using it frm my pc it works fine but frm client pc it does not connect to database. error on this line.... conn.open() on client pc sql-server client utility is installed wht to do.. i m very much confused reply ASAP.. Ajay
-
my connection string is Constr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=;Initial Catalog=TestCapex;Data Source=192.168.41.2" m using DSN-Less connection. plz help i m very upset..
-
my connection string is Constr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=;Initial Catalog=TestCapex;Data Source=192.168.41.2" m using DSN-Less connection. plz help i m very upset..
192.168... is an internal IP address. Make sure you use the correct IP address if your client is outside of your local network.
Jonathan Sampson www.SampsonResume.com
-
my connection string is Constr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=;Initial Catalog=TestCapex;Data Source=192.168.41.2" m using DSN-Less connection. plz help i m very upset..
-
Unless the IP you gave us is fake, the 192.168 is a "safe" ip address used internally for networks. can the user's PC get to that IP address? ping it from the user's pc to check.
i have pinged and getting the reply frm 192.168.41.2 frm my clients PC. also my client is in our local network.. any suggetion
-
192.168... is an internal IP address. Make sure you use the correct IP address if your client is outside of your local network.
Jonathan Sampson www.SampsonResume.com
ya my client is in our local network.. and one thing which shd be noticed here is that i m getting access frm my PC but not frm my client's PC.. now i have given public access to the database. any suggetion
-
i have pinged and getting the reply frm 192.168.41.2 frm my clients PC. also my client is in our local network.. any suggetion
- by chance is your sql server using a different port then what is the default? try adding the port to the data source 192.168.41.2,????? i've seen where my PC doesn't have to give the port but other pc's do...explain that... 2) if that's not the case, try setting up a temporary DSN and make sure the PC itself has no issue connecting to the database. 3) is the PC up to speed on MDAC versions