Remote Database connection

[tomhughes]

I am using Dreamweaver MX, connecting to a remote server, which uses a MS SQL database. I can connect to the database sometimes, and sometimes I can't. In other words when I go to the Application, Database, Tables, it shows none, but they are there, and they ae working on the web site.

 

[Catadmin]

Describe how you are connecting to the SQL Server please. I.e., are you using an ODBC, etc.

Are you getting any error messages when you can't connect? If so, please post them.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[tomhughes]

I am using an OLEDB. Here is the connection string I am using:


"PROVIDER=SQLOLEDB;DATA SOURCE=mssqlxxxxxxxxxxxx;UID=dbxxxxxxxxxx;PWD=sKxxxxxxx;DATABASE=dbxxxxxxxxxx"


THe problem occurs during development, not during run time.
There is no error message, it just takes a long time to test the connection, then it stops. When I go to the development window in Dreamweaver it shows tables to be "none".

 

[tomhughes]

Well there is an error message, and here it is:

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

 

[Catadmin]

Are your development machines different from your production machines? What about the SQL Server? If you've got 2 different databases (with the same data), chances are you don't have the user connection set up the same. Either the login name is slightly different or the password is.

Also, I've found my connections "die" when I've restored the database to Dev and forgotten to go through and fix the logins with sp_Change_users_login.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[tomhughes]

The database works during runtime, but not always during development time. The connection script is the same for both.

 

[Catadmin]

Tom,

Sorry, but I'm still not clear by what you mean by that statement.

Do you have 2 different servers or are you working off the same server? Do you have 2 different Databases or are you working off the same database?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[tomhughes]

I am using one Server, one Development Platform, and one Data Base.

 

[Catadmin]

So, when you say Development Platform, you're literally talking about Dreamweaver? Or are you talking about a PC?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[tomhughes]

My Development Platform is a PC with Dreamweaver