Urgent Prob- ODBC Connection to .DBF database
molly
I have an urgent prob connecting a .DBF database using Microsoft
Visual Studio 2008. Now i am just trying to connect it on my own
computer before trying to connect it on the company server later. Here
is what i did, hope experts here can help me out:
My database directory is c:\Callcenter\dbfs\MAILALERT.DBF
From Control Panel' s ODBC Data Source Administrator, i chose dBase
Files(*.dbf) -> Add -> Driver do Microsoft dBase (*.dbf) (here i do
not know which driver is the right one to pick) and create a source
connected to my local DBF database(dBASE III), name it "MAILALERTNEW"
Then in Microsoft Visual Studio 2008, I created new project, add form,
then add Project Reference: Add Microsoft ActiveX Data Object 2.7
Then from ToolBox under Data, I add "ODBC Connection", I drag it to
the form, in its properties-> new connection, its connectionstring
becomes "Dsn=MAILALERTNEW"
From Visual Studio top menu, Tools-> Connect to Database, I was able
to connect the target database MAILALERT.DBF, It looks like successful
when “Test Connection”. Then I was trying to think how can I make
those data show up on my form after the connection is set up??
From ToolBox, I dragged “DataGridView” to my form and it goes to “Add
Project Data Source” -> Database -> I chose my target database as a
new connection, test it ok, then “Which database objects do you want
in your dataset?” -> I picked “Tables” and “Views” ->
Then it says Error occurred <C:\Callcenter\DBFS…MAILALERT> Could not
get column information for database object named…
Does Any of you can help me out with the problem?
I am a new comer, is there anything wrong with what I did to connect
the dbf? How can I make the data show up or even update some data?
Any ideas or suggestions? I appreciate it so much
My email: molly...@gmail.com CRY FOR HELP!!!!!!!