M
Mohan
hello sir,
i created a file dsn named test1 in the path "C:\Program Files\Common
Files\ODBC\Data Sources\test1.dsn".
in my form item_open () event i written the following code
Function Item_Open()
set cnn = application.createobject("adodb.connection")
cnn.open "test1","admin",""
msgbox "success"
End Function
but i got the error like
"[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified Line no:3"
but the same thing is working for User DSN and System DSN.what shall i do?
kindly help me with u r guide.
thx
mohan
i created a file dsn named test1 in the path "C:\Program Files\Common
Files\ODBC\Data Sources\test1.dsn".
in my form item_open () event i written the following code
Function Item_Open()
set cnn = application.createobject("adodb.connection")
cnn.open "test1","admin",""
msgbox "success"
End Function
but i got the error like
"[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified Line no:3"
but the same thing is working for User DSN and System DSN.what shall i do?
kindly help me with u r guide.
thx
mohan