Setup a SQL DB in Coldfusion Administrator

[monoone]

Hello;

I have never setup a SQL Server DB in Coldfusion administrator.

Do I have to give it some sort of path name?

It doesn't give me a listed directory like it would with and access db.

Any ideas?

Thanks,

Eric

 

[Sarky78]

when setting up a SQL datasource you specify the database server in the server option (this can be an ip address or a sserver name that can be resolved) this is like you path name. in the database field enter the name of the actual database as seen in enterprise manager. and then enter the login details that are used to authenticate the user in the username and password fields.

this is the basics of setting up a SQL connection, opening up the advanced settings will give you more options such as what to allow to happen on this database - select, delete update etc.

hope this helps !

 

[monoone]

How do I Make sure that my ODBC driver is configured to pass long text?

-Eric