Thread: Login failed

Hi Fusion

Very sorry for the delay. I hope you got the addin working ok.. I saw the message you posted up the other day but I have been working very hard at work and not able to get time to do anything on the addin. Sorry for that.

If you are still trying to get the addin working, will do my best to help you out if you still want to look into it.

For the addin, if you are still have the problem, I would first check to see if you can connect to a different datasource without a problem (you could try an access database or excel sheet or something else)

If this does not work, then it would seem like there is a problem with one of the dependencies - probably the ADO library. In this case, I would try re-registering the ado ibrary DLL that you are using - to see if this helps.

If you can connect with a different datasource (say access) without a problem but still no joy with SQL Server, the first thing I would try would be to see if it is because you have the \"Save Password\" checked on the connections form. This should not be an issue usually - but I know someone had this problem before with MYSQL so I would try that.

I would also try to use a different odbc driver to connect - to see if this is possible. If you are using the SQL Server ODBC, you could try the OLE DB maybe to see if that is ok.

Also, you could try different database server, and/or different database. Also, you could try with another User ID.

All of the above would be just to try to narrow the issue down.

Please let me know how it is going and if I can help with something.

Thanks and have a nice weekend
Alec

Forgot to mention,

please could you look into the error log to see if there is a more detailed error message there.
The error log is normally in the following folder
C:\\Documents and Settings\\[YOUR USER ID]\\Application Data\\sqlexcel

Hopefully, that will help find out what is going on with this problem.

Sorry again for the delay in looking into this.
Al

I too have had a login issue. Installed okay, set up a test connection without issue, now trying to connect to our SQL server and getting a login error when creating the connection.

Checked the log

02/11/09 11:38:33 [SQLExcel]formSQLNew.CommandConnect_Click, Error -2147217843: Login failed for user \'my user name\' (CommandConnect_Click)

I can connect with the credentials from the app I work in (which uses an IBM odbc connector).

I checked with the SQL server admin and they said I need to specify a port - Is there a way to specify a connection port in SQLExcel??

Cheers

J

Hi
Sorry, you are having the same issue.

The addin only wraps the Microsoft Connection componets (basically MDAC..) But you can specify a port in the connection string. Please see below (port 1510 is specified)

Code:

sConnectionString = \"Provider=SQLOLEDB;\" & _ 
        \"Data Source=127.0.0.1,1510\\instanceName;\" & _ 
        \"Initial Catalog=northwind;\" & _ 
        \"Network=DBMSSERVER;\" & _ 
        \"User ID=<uid>;\" & _ 
        \"Password=<pwd>\"

Basically, you can manually go in an add the port number into the connection string as shown in the example above.

Please let me know if this works ok.

Have a nice evening.

Al

Al, you are a genius!

Worked without issue thanks.

Also thanks making this great little tool available!!

Cheers

J

Awesome !
Would be great if I was as we wouldnt be having so many probs :P
But that is real cool you got it going.

Please feel free to post up any feedback. There are alot of areas for improvement with this addin and hopefully we will have a great tool one of these days.

Take it easy and thanks

Al