Program runs on system with SQL and Codegear Only

[sbarrett2008]

I created a program that converts Paradox tables into a SQL 2005 database. The program runs fine on my development system, and it runs on another system after I installed Express SQL and Codegear 2007 on it.

It won't run on the production machine. The production machine routinely uses the Paradox OBDC connection. I have imported data from the SQL database into an excel spreadsheet. I'm fairly confident that the connections are correct.

I can run the program on the laptop using the user name and password (from the production machine). This rules out rights issues.

The specific error I am getting is:

Schema or user name separated by a '.' must be specified.

Any suggestions would be helpful.

 

[whosrdaddy]

are you using BDE to interact with the paradox tables?


-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[sbarrett2008]

Yes, I use BDE to interface with the paradox tables, and SQL Native Client to interface with the SQL 2005 Server.

 

[whosrdaddy]

you must deploy the BDE engine on the system where you wish to use the program.

For more info, check out this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1365868

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[sbarrett2008]

The system has BDE installed along with the SQL Client. Both the production system and the development system uses the BDE to interact with other paradox tables for a separate application.