unable to verify ODBC socket datasource

[jafo]

In the CF Admin, I am trying to create an ODBC Socket datasource to a System
datasource that is pointing to an Excel file. I receive the following error in
the CF Admin:

[Macromedia][SequeLink JDBC Driver][SequeLink Server]Unable to retrieve error
message from backend ODBC Driver.

I am able to successfully create this datasource on our development server.
The sequelink drivers are the same version although we are currently running MX
7 on our development server and MX 6.1 on our production server.

Any suggestions? I've searched the 'net for a couple of days and have run out
of possibilities.

[mxstu]

I know this isn't an answer your question, but what do you need to do with the excel file?

[ecolucci]

Since you didn't specify, I am not sure you tried this: Did you first create
the data source (as a System DSN) using the Microsoft ODBC Administrator on
your physical server? If you did then once you are in the CF Administrator,
you should be able to select your data source from a drop list after you name
your data source ("second Web page" used in creating data source in CF Admin).
Select "Advanced Settings" and be sure to uncheck the box that reads "Maintain
connections across client requests."

[jafo]

The Excel file is used as a report template

[jafo]

ecolucci ,

Yes, those are the steps that were taken. Well, those are the steps that were
taken on our dev server and I sent our SA those instructions to create the
datasource on our production server. I sent him a list of links to possible
solutions and he apparently got it to work, but he didn't tell me what he did
to fix it. *shrug*

Since your post has the steps needed to create the datasource, I'll mark it as
the answer. It should be that simple! :)

[mxstu]

jafo,

If you get a chance, can you ask them what fixed it? I'm curious because I
received the same error when I tried to create the DSN in CF Administrator and
would like to know what the correct settings are. (Yes I created a system DSN
first). Thanks