Ask a Question related to Dreamweaver AppDev, Design and Development.
-
oscar #1
Connecting to SQL server
Are settings configured wrong? Of course both possible reasons given
are both true, that is the web services is up and running and the ODBC
DSN does exist on the server. Remember DW does connect to the SQL
server to build the Connection String but fails later at the "OLE DB
Connection" window. Why does my FTP server come up when the SQL server
timeout occurs? My SQL server server is my ISP's and so is my FTP. I
read johndoe01's thread about the permissions problem. Doea that come
into play here?
oscar wrote:> Greetings,
>
> I am trying to connect my asp.net page to my sql server. I have
> attempted to create a connection through the OLE DB Connection dialogue.
> I insert a connection name and "Build" the Connection String through
> the "Data Link Properties" dialogue. My connection succeeds through
> this "Data Link Properties" window and I hit OK. I am then back on the
> "OLE DB Connection" window; I hit test and another little window comes
> up that is labeled with my ftp server and I get the following message:
> "A server timeout occurred. Here are the possible reasons. 1. Please
> make sure the web service is up and running. 2. Please verify that the
> ODBC DSN exists on the testing server. What is happening?
>
> oscaroscar Guest
-
Connecting SQL Server with DW using ASP.NET VB
Hello All, I'm trying to connect SQL Server with DW using ASP.NET VB using several connection strings and getting different error messages. The... -
connecting to dsn on server
I have a website on a shared server at CrystalTech. They say: Your data source verified. The connection string you should use in your code is... -
Connecting SQL Server to DW
Hello I'm I have a project that is due shortly and I have been trying for about a week to connect SQL Server with DW with no success. I have read... -
Connecting to SQL Server from ASP.NET
Hi, Hi I have SQL Server Instances running on same machine. How do i connect to the "SecondInstance" of SQL Server on a machine from ASP.NET? ... -
Web Server connecting to Informix Server
I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we... -
CFGoneWild #2
Connecting to SQL SERVER
I'm just starting with Coldfusion. I used it several years ago before
MacroMedia purchased it.
I'm testing the Northwind Database connection.
-- (local) as the database name
-- the default port is 1433
-- no username or password
-- sql server database is up and running
when it goes to verify the connection, it TIMEOUT.
what could be wrong?
CFGoneWild Guest
-
Sojovi #3
Re: Connecting to SQL SERVER
(local) should be the Server Name, not the database name. You need a username and password to connect to SQL server. Start with those and then will see.
Regards
Sojovi Guest
-
CFGoneWild #4
Re: Connecting to SQL SERVER
yes, (local) is the Server name.
however, i use Windows Authentication and I have NO username or password on
the local database.
Do I need to set one at the SQL Server level or Coldfusion level? And where do
I set the password? I thought I read in the CF documentation, that username and
password should be left blank.
In the Connecting to SQL SERVER section of Cold Fusion, it has the following:
To set up the database in the ColdFusion MX Administrator:
Open the ColdFusion MX Administrator.
Click Data & Services > Data Sources.
Type northwind in the Data Source Name field, and select Microsoft SQL Server
in the Driver drop-down list box.
Click Add.
Type Northwind in the Database Name field, 127.0.0.1 (or the database server
IP address) in the Server field, and 1433 in the Port field.
Note: Do not specify a user name or password when defining the data source.
Save the data source.
CFGoneWild Guest
-
CFGoneWild #5
Re: Connecting to SQL SERVER
Thanks. I figured it out.
I had to an a User in the SQL Server User Table; and setup a Username / Password for each user.
The CF documentation says otherwise..oh, well...thanks!
CFGoneWild Guest



Reply With Quote

