connect to SQL

[boato]

Hello,
I am trying to connect to SQLServer 2005 Express Edition.
I follow the instruction in Video 2 on macromedia website. In the video they
choose ACCESS. In it one only need to fill in CF DATA Source Name and Database
field. I choose the SQL connection in Application/Databases and there one also
needs to write in the Server field. I get an Error message if I do not write
in the Server field. Unfortunately I do not know what to write in the Server
field. Can somebody please help me with this.

[Sojovi]

Server is the name of the SQL 2005 instance where you want to connect.

Regards

[boato]

I tried to do this, but it didn't work. I hope somebody can tell me what I am
doing wrong.
The name of the SQL 2005 instance is MyDB.mdf
I fill in the Microsoft SQL Server Connection:
CF Data Source Name: MyDBConnectionString
C:\CFusionMX7\wwwroot\K_5\MyDB.mdf
Server: MyDB.mdf
I get an Error message when I try this: -1:Error establishing socket. Unknown
host: MyDB.mdf

[Sojovi]

No, the name of the SQL instance is not that. To view the instance name, go to :
SQL Server configuration manager -> SQl server 2005 services , and in the
right panel you'll see the name of the instance running (beetwen parenthesis)

Regards

[cshow365]

Hello,
I'm also having trouble doing this!

In the CF Administrator ....

What do I put in the "Database" field?
Is this the full path to the database I created in mssql?
Should it be placed under wwwroot?

What exactly do I put in the "Server" field?
I followed your direction Sojovi, the (between parenthesis) is
SQLEXPRESS. Does that sound right?

What do I put in the "port" field?


Is the above all I need to provide?


This is a huge learning curve for me.
Thanks!
-Gary

[Sojovi]

OK, let's review :
Server -> View previous post (i.e. SQLEXPRESS)
Database : The name of the database you want to connect to (i.e. the famous
"Northwind")
Port : Usually 1433
And you'll need a username and password, that you create in the management
studio and assigns access to the database desired.

Regards