C
|
chris 12/11/2006 |
Since switching to ASPRunnerPro 4.1 (Build 164) I seem to be having problems re-opening projects I have saved. I've built a project using a SQL ODBC with the following details Data Source Name: RCDB on eESM Data Source Description: RCDB on eESM Database: eESMmaster I successfuly built the site, and saved it. Now, when I try to re-open the project I get this error: SQL Error State:42000, Native Error Code: FDC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'eESMmasterDSN=RCDB on eESM'. Login fails. I click OK, then get this very long error that shows: Error connecting to database: DSN=RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123DNS=RCDB on eESM;Description-RCDB on eESM;UID-rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmasterDSN=RCDB on eESM;Description=RCDB on eESM;UID=rcdbuser;PWD=rcdbuser123;APP=AspRunner Professional Application;WSID=RCONBK52937;DATABASE=eESMmaster Not a SQL guru, but noticed that the Database= string and the DSN= string are not seperated by a ";" (i.e. DATABASE=eESMmasterDSN=RCDB on eESM)...Does that matter? I have not changed my ODBC connection in anyway, and verifyed/tested that it connects as is. Basicly, nothing has changed between the time I saved the project and the time I re-opened it. Unfortunatly, If I point it back to the same ODBC connection, I loose all of the work I have done. I tried to rebuild it and save it again, but the same thing happens. It is also happening on another site I build using a different ODBC connection/database.
|
S
|
semleon author 12/12/2006 |
I've installed the latest build, but I am still unable to open any of my projects. I'm getting the same error message. |
S
|
semleon author 12/20/2006 |
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=14017&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> Still having the same problem. Cant figure out why. Having to re-create my projects everytime I want to make a change. VERY time consuming and needless. Please help........ |
![]() |
Sergey Kornilov admin 12/20/2006 |
Connectiong string seems to be corrupted. |