Please help with ConnectionString to SQLAnywhere 5.0

  • Thread starter Thread starter oswald verlinden
  • Start date Start date
O

oswald verlinden

Hi all,

i have a client with an old working app. in PowerBuilder for which i
need to create new modules.
The db is sqlanywhere 5.0.4
The db is configured in ODBC.
Now, i don't seem to be able to connect to this db.

Can anyone help me with the connectionstring and maybe references to
add?

string connectionString = "Data Source=Ghoenix;uid=dba;pwd=gerling";
Conn = new OdbcConnection(connectionString);

try{Conn.Open();}
catch(Exception ex){MessageBox.Show(ex.ToString());};

He keeps giving : datasource & driver not found...

Help would greatly be appreciated,
Oswald
 
i found it myself
SQLAnywhere 5.0 is supported by ODBC 2.x instead of 3.x
And this string worked just fine!

For everybody's information (if ever needed):
 
Still had problems with security issues, but this one is a winner :

String ConnectionString = "Provider=MSDASQL;DSN=Ghoenix;UID=dba;PWD=gerling";
 
Back
Top