PDA

View Full Version : connection problem usin sqloldb


jsaullo
05-14-2009, 04:19 PM
I am having a problem using dreamweaver ultradev to return a record set.

the connect string is as follows:

Provider=SQLOLEDB ;Data Source=sqlapps2\apps2;Initial Catalog=fh;User Id=fhweb;Password=XXXX;

when I test the connect strinng it works fine

I created the following record set containing this SQL

SELECT DISTINCT(MAIN_ID) MAIN_ID ,descript
FROM dbo.HYD_MAIN join lkp_hydr on MAIN_ID = code
WHERE RTRIM(MAIN_ID) > ' ' and category = 'MAIN ID'
ORDER BY descript


when I test it in the server behaviors it functions fine


If I preview the asp form in IE I get the following error

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


if the form runs from the web server the error does not appear. One other joyful thing is that this error only occurs on this instance of SQL, the other ones function fine.


any ideas would be helpful

davidj
05-14-2009, 10:24 PM
WOW ultradev. Brings back memories. (I remember drumbeat!)

Dreamweaver ultradev is getting very old now.
Im guessing it could be a jet driver or your connection string is incorrect.

I am not an ASP dev so i cant debug your code

I suggest that you learn to hand code or buy an updated IDE

jsaullo
05-15-2009, 11:24 AM
for the most part I do hand code the form. The problem was not so much that the code does not work it just fails with this one instance of MS SQL from my machine. If I move the that database to a different instance the code functions from my local machine. For the life of me I can't identify any difference in the sql installs. (I'd ask the DBA but I'm him)

davidj
05-15-2009, 06:03 PM
I'd ask the DBA but I'm him


at work a DBA stands for ... Dont Bloody Ask!

if the application is working then dont try to get your IDE to integrate using the connection string

just hand code the lot

I would advise that you upgrade from ultradev. Even if its to eclipse or notepad++

jsaullo
05-15-2009, 06:07 PM
I would if I could but the mere mention of it leads to my don't you use visual studio and c# like all the others (and take four weeks to produce something that takes a day and a half )