I am using ADO version 2.1.

When Using two different connect string to connect to same oracle
database, it will return different type of result.

1) cConnectStr = "driver=microsoft odbc for oracle;User
ID=joel;Password=zaq12wsx;Data Source=HIS"

2) cConnectStr = "driver=microsoft odbc for oracle;User

for no.1 connect string, It only accept number field type, when
selected data field type are number(2) or number (4,2) .... will
return error message.

for no.2, no error occur for what ever number field type.

So Can anyone please tell me what the different between Data Source
and Server and why No.1 Connect string return error.