DB Connection string

[draganss]

Application for HP IPAQ (VB.NET 2003)

ConnString =
"server=" & SrvName & ";" & "database=" & DBName & ";" & "user ID=" & UsrName & ";" & "password=" & UsrPwd & "; Connection Timeout=20"

When I use this connection string to connect from HP IPAQ to an DataBase on Win Server 2000 (SQL 2000 Entreprise Edition) it is OK.
Same application and same database but on Win XP Pro (SQL 2000 Personal Edition) gives me an error.

What is wrong?

Thanx, Marin

 

[vbkris]

wht error does it give???

Known is handfull, Unknown is worldfull

 

[Jasen]

For SQL Server 2000, I use a connection string in the format:
"Provider=SQLOLEDB.1;Password="SomePass";Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=localhost"

Now, being on an Ipaq, I'm not sure how that would change. Guess it depends on the pocket PC MDAC equivalent?

 

[mrdenny]

Check out

http://www.connectionstrings.com.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[smnetto]

U have to add: "Provider=SQLOLEDB;" in your string.