[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

database not recognized

my database is not reconized although I see it in the coldfusion administrator as an access database
I get a message error=()
What does this mean ? I spent days trying to find the problem but...
thanks for your help
Mimi
0
mimilafleur
Asked:
mimilafleur
  • 9
  • 7
  • 3
1 Solution
 
deepchandaCommented:
Are you able to verify your datasource ?when do you get this error message ?

DC
0
 
bigbadbCommented:
have you set up an odbc connection through NT or win95 whatever you are using.  Goto the control panel and make sure that odbc connection is established then it should work in cf
0
 
mimilafleurAuthor Commented:
Hi Deepchanda,
How do I verifie my datasource ?
It is on my computer for sure.
I get this answer when I try to run my coldfusion program(.cfm)
the exact error is:
Error Diagnostic Information
 
 ODBC Error Code = ()
 
 Unsupported ODBC data source TIBIBLIO1 for ColdFusion Express. The data source may not exist or no driver is specified for
 the data source.
Thank you for your help
Mimi
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
mimilafleurAuthor Commented:
How can I accept more than one answer
thanks
0
 
bigbadbCommented:
you can post another question and let me answer it then you can give me some points

Thanks for being fair

0
 
bigbadbCommented:
the error you got above tells me that you havent created an odbc session for your database

do this and you will be set
0
 
deepchandaCommented:
You should have "microsoft access driver" in the ODBC drivers drop down list which allows you to add access datasources on a access mdb file. Also every datasource been defined from the CF admin page is based on the system ODBC in the control panel on your server computer. make sure that you have the ODBC drivers for access database

DC
0
 
mimilafleurAuthor Commented:
well dear bigbadb, I don't know how to create an odbc session for my database. don't tell anyone.
seriously, i am stuck.
thanks for your very well appreciated help
Mimi
0
 
mimilafleurAuthor Commented:
well dear bigbadb, I don't know how to create an odbc session for my database. don't tell anyone.
seriously, i am stuck.
thanks for your very well appreciated help
Mimi
0
 
deepchandaCommented:
the CF admin page where you can verify the ODBC datasource is located at http://yourserveraddress/cfide/administrator/index.cfm, and you click on ODBC link from the left panel. ONce you have a datasource created on that page, CF will try to verify that DS for you. Also you can goto your system control panel, ODBC, system DSN and create that datasource. Let me know if you need more help on this

DC
0
 
deepchandaCommented:
Following are the steps to create a datasource for access from the system control panel:

1. Goto system --> control panel --> ODBC

2. while on the ODBC panel, select "system DSN"

3. Click on "Add", which gives you a list of all the database drivers available on your computer.

4. Select the one for Access database and click on "finish"

5. Enter a name for the datasource, and select the mdb file

6. Thats all , you have the datsource created for you.

This would also show up from the CF admin pages

DC
0
 
deepchandaCommented:
Following are the steps to create a datasource for access from the system control panel:

1. Goto system --> control panel --> ODBC

2. while on the ODBC panel, select "system DSN"

3. Click on "Add", which gives you a list of all the database drivers available on your computer.

4. Select the one for Access database and click on "finish"

5. Enter a name for the datasource, and select the mdb file

6. Thats all , you have the datsource created for you.

This would also show up from the CF admin pages

DC
0
 
mimilafleurAuthor Commented:
hi deepchanda,
It didn't work at all! I followed all the steps. I get exactly the same error
thanks
Mimi
0
 
mimilafleurAuthor Commented:
hi deepchanda,
It didn't work at all! I followed all the steps. I get exactly the same error
thanks
Mimi
0
 
mimilafleurAuthor Commented:
why are the quetions posted twice ?
What do you with this points ?

Mimi
0
 
deepchandaCommented:
try verifying this from the CF admin page. is TIBIBLIO1 the name of your datasource ?
0
 
mimilafleurAuthor Commented:
why are the quetions posted twice ?
What do you with this points ?

Mimi
0
 
mimilafleurAuthor Commented:
hi deepchanda
It finally worked (thanks to you).
I recently installed office 2000. I converted my old database and it worked.
You deserve more than 50 pts.
Thanks
Mimi
0
 
deepchandaCommented:
sure mimi, i think the install of office 2000 did it
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 9
  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now