Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 "Dialog failed" error, connect string

Author  Topic 

proexpert
Starting Member

1 Post

Posted - 2013-10-28 : 00:05:00
I'm very new to SQL. I'm using a 3rd party application that allows me to get data from Excel and pass it to an SQL database.

I installed SQL express and created the database and a table. I think all of this is okay. I can upload a screen shot of the database if that will help.

I'm having trouble with the connect string that I pass to SQL, I get the "Dialog failed" error message.

The server is called publisher
The database is called cadquest

The error message:
[Microsoft][SQL Server Native Client 11.0]Dialog failed

ODBC_CONNECT "Driver={SQL Server Native Client 11.0};Server=\\publisher\sqlexpress;Database=cadquest;Uid=xxxxx;Pwd=xxxxx"

I replaced the user id and the password with xxxxx for this posting.

Thanks for helping me. I'll get help from the application support guys tomorrow but I figured I might learning something here.
   

- Advertisement -