Deploying DB application

[Faded]

Hello,

I'm working on a database application using Delphi 5 as a front end, and I'm having problems deploying it to client machines. I was hoping someone could provide some insight as to why it is not working.

So, as I said, it is a db app and uses an ODBC to connect to MS SQL server 7. On the client machine that I am trying to deploy to, I have the latest MDAC installed, as well as the Borland Database Engine, and a DSN to the remote database. When I run the application, I get "table not found" and "procedure not found" errors.

I am using the InstallShield that comes with Delphi for the install and one thing that I am wondering about is when I have to specify any aliases the app uses, it doesn't give me the ODBC option for alias type, just paradox, interbase, etc...

For some reason the client machine is not seeing the DB. Any ideas why?

Faded

 

[scottostanek]

Not that I know anything about MS SQL server 7 --I don't-- but I have had similar errors in setting up ADO connections to Access 97. It turned out I had a table or query that was active before I connected to the ADOConnection. It works fine on the development machine because it is opened when Delphi is (with the project anyway). Check to be sure all datasets are closed and that the database connection happens first.

I also had a similar situations with Advantage db server
but in that case I was using UNC path to make the database connection and it wasn't resolving fully until after I tried to open the first table --foobed. That was fixed by making sure the client machine had a mapped drive letter(any would do) to the volume on the network the database resides on.

Scotto the Unwise