Opening a silent connection to SQL

[DvDvDvDv]

Hi all,

I've got a problem. If somebody has the answer please reply my issue.
I'm programming a software in VB which opens a Microsoft Project file. This file is connected to a SQL Database using a dsn.
My problem is: When my software opens the microsoft project with a file, it prompts always a confirmation to open the database using the password I registered on the dns and on my software.
What I want is my software open the database silently, mke the changes to my file and close it without prompting a confirmation.
More information: I registered the password and user on the software and the dsn connection...

How can I do this ?

Please help me

Dv

 

[vbkris]

do connection string show the same errors?

Known is handfull, Unknown is worldfull

 

[DvDvDvDv]

No.

There is no error. My problem is when the MS Project opens, try to use the database in sql and shows a window asking for a confirmation (in the window we can see the connection string used by the dsn).
Its just a confirmation. What I really want is the project opening a SQL database without this prompt window.

Dv