Iam creating an Interface to access Progress Database for a client.
I have an application (VB 6), and when i create a DSN connection, i get teh following errors. Note that one has a DSN and teh other one doesnt have.
Please help me sort out this problem
sapmle 1 dsnless
connection.open "PROVIDER=MSDASQL;Driver={MERANT 4.00 32-BIT PROGRESS};DB=AUTOMATE;UID=userid;PWD=pwd;OIDP=TCP;OIDS=BROKER;OIDH=196.34.200.1;DBAM=VIASERVER;DBPR=TCP;DBS=AUTOMATE;DBH=196.34.200.1;ASC=0"
sample 2 dsn??
connection.open "DRIVER={MERANT 4.00 32-BIT PROGRESS};DB=AUTOMATE;OIDP=TCP;OIDS=BROKER;OIDH=196.34.200.1;DBAM=Direct;DBPR=TCP;DBPA=DATABASE PATH;DBOS=Windows;ASC=0;SR=0;GST=0;UID=userid;PWD=pwd"
i get error -2147467259: [microsoft][PDBC Driver Manager] Datasource name not found and no dfault driver specified
I have an application (VB 6), and when i create a DSN connection, i get teh following errors. Note that one has a DSN and teh other one doesnt have.
Please help me sort out this problem
sapmle 1 dsnless
connection.open "PROVIDER=MSDASQL;Driver={MERANT 4.00 32-BIT PROGRESS};DB=AUTOMATE;UID=userid;PWD=pwd;OIDP=TCP;OIDS=BROKER;OIDH=196.34.200.1;DBAM=VIASERVER;DBPR=TCP;DBS=AUTOMATE;DBH=196.34.200.1;ASC=0"
sample 2 dsn??
connection.open "DRIVER={MERANT 4.00 32-BIT PROGRESS};DB=AUTOMATE;OIDP=TCP;OIDS=BROKER;OIDH=196.34.200.1;DBAM=Direct;DBPR=TCP;DBPA=DATABASE PATH;DBOS=Windows;ASC=0;SR=0;GST=0;UID=userid;PWD=pwd"
i get error -2147467259: [microsoft][PDBC Driver Manager] Datasource name not found and no dfault driver specified