Here you go
OP wrote:
I tried that, and i got this error.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Do you have any suggestions regarding this error
This usually happens in one of the following scenarios:(Quote taken from below link)
# you referenced your connection incorrectly (e.g. spelled the DSN name, or one of the DSN-less string components wrong);
# you referenced a DSN that doesn't exist;
# the user connecting to the DSN or DSN-less connection doesn't have access to the information stored in the registry (see KB #306345);
# you used an English or localized driver detail for your connection string when your system is not set up in that language (see KB #174655); or,
# you are missing the connection string entirely (this can happen if you maintain your connection string in a session variable, and your sessions aren't working; see Article #2157).
80004005 Errors[
^]