Please help with ConnectionString to SQLAnywhere 5.0

[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

[oswald verlinden]

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):
---------------------------------------------
String ConnectionString =
"Provider=MSDASQL;DSN=Ghoenix;userid=dba;password= gerling";
OdbcConnection myConnection = new OdbcConnection(ConnectionString);
myConnection.Open();

os**************@skynet.be (oswald verlinden) wrote in message news:<1c**************************@posting.google. com>...

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

[oswald verlinden]

Still had problems with security issues, but this one is a winner :

String ConnectionString = "Provider=MSDASQL;DSN=Ghoenix;UID=dba;PWD=gerling" ;
os**************@skynet.be (oswald verlinden) wrote in message news:<1c**************************@posting.google. com>...

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