Araphoenix Hatsugen

I realized that Coldfusion is not really a great scripting language, although it’s free, oh! Not free but you can illegally own a pirated copy on it but in installing it’s not! Since my Drive C was reformat cause someone deposit a virus or a spyware on my Drive C, my YM sending viruses all my YM contacts, and it is totally disturbing, and I hate virus so I right away  reformat , of course I  backed up our projects, put it on the Drive D, and the database, bahal na uy! Usbon na lang nako.

Okie then, I use Windows XP SP 1, para gamay lang, I installed my Coldfusion, connect in to my SQL server 2000, and the connection was successful, so my internet technology project is okay na! But then, when I started to install my C#, it won’t, I forgot that the software requires SP2 + OS. So, I upgrade it into SP2, so successfully installed my c#, okay so okay na! But unfortunately, when I tested again my Coldfusion website, it won’t connect to the database anymore, and the error said:

 

Connection verification failed for data source: data
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login ‘new database_Data’. Login fails.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login ‘new database_Data’. Login fails.

 

 So I got pissed off!

But thanks to google, the connection goes back. Hey If you experienced problem like this or same error like mine, here’s the thing:

 

The problem is Windows XP SP2. It enables the firewall, so I have no idea where the firewall is is so that I can disabled it, if possible. But there’s another procedure for the connection, the work around is to route your CF Admin Datasource connection through an MS ODBC socket, whatever that is. Here is how in more detail than the other threads have:

 

1) First go to Control Panel / Admin Tools / Data Sources (ODBC) and under

the System DSN tab add a new data source. Choose whatever name you like such

as mycompanyODBC, whatever description you like, and then choose an active

DB server on your system that you want to point to.

 

2) For authentication choose whichever you want but Windows NT is easiest

because that is your computer login.

 

3) Select your database that you want to address with CF then finish the

wizard.

 

4) In CF Admin Data Sources pick a data source name that makes sense to you,

such as mycompany_db, then choose ODBC Socket for the driver instead of

MySQL, SQL Server, or whatever.

 

5) The ODBC DSN should be the one you chose above in step 1, the user name

is system and no PW unless you want something more secure. Click Submit and

it should verify.

 

Hint: To save trouble when uploading your CF CFC or CFML page to the host

server you should choose the same datasource name on both the development

and the production (hosting) server. Your code shouldn’t have to know about

this work around.

 

Then, I am happy..:)

 

Here is the picture: