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.
| Author |
Topic |
|
CanyonMan
Starting Member
1 Post |
 Posted - 2010-03-22 : 11:25:54
|
| I'm hoping that this is just a newbie error and my Google-fu is just weak but I'm just very confused. I have an Access 2007 .adp project connecting to my SQL 2005 server using SQL authentication embedded in the code. I have had this exact piece of code working perfectly for about 7 years. I copied the adp to my Windows 7 Enterprise 64-bit machine and the code throws a 'login failed for user: FormUser'. I know that MS sometimes has issues with the error not really being the actual issue but when I look at the SQL logs I see a matching error, "Error: 18456, Severity: 14, State: 8." which is a password error. I have done the following in trying to solve this:1. Created a new user and created a very complex password. - No change.2. Changed from SLQOLEDB to SLQNCLI (with data compatability=80). - No change.3. Tried to run in on a Windows 7 Enterprise 32-bit. - No change.4. Turned off password complexity checking. - No change.5. Tried server name, FQDN, & IP. - No change6. Changed the connection to windows authentication. WORKS. (But it violates my entire process)Here's the code I'm currently using:Public Function SqlConnection() Dim oConn As New Adodb.Connection With oConn .Provider = "SQLNCLI" .ConnectionString = "Data Source=Aphex-Kappa;" & _ "Initial Catalog=NewWhiteCard;" & _ "DataTypeCompatibility=80;" & _ "User Id=FormUser;" & _ "Password=<redacted>" .Open End With SqlConnection = oConnEnd FunctionI'm really quite confused as to what this could be as I'm using the same version of Office 2007. I have cut and pasted this info into an ODBC connection (both 32 & 64 bit) and connected just fine.Any thoughts would be very welcome,-CanyonMan |
|
|
|
|
|
Access 2007 VBA code that works in XP but not Win7