[Webinar] Streamline your web hosting managementRegister Today

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

How to Open the FILE dsn in vb6 coding ?

I have created two FILE dsn one for Mdb and the other for dbf (Ms-Vfp). I am unable to access the database or dbf specified thru the created dsn. I want to open the Data files attached with the above dsns thru coding.If i copy the FILE dsns in some other remote machine will it work ?
0
krs_rama
Asked:
krs_rama
1 Solution
 
Ryan ChongCommented:
what're the FILE dsns look like?
0
 
mpaul4uCommented:
hi,
FILE DSN  WORKS IF COPIED TO REMOTE machines.
create dns same way as other dsns.from control panel
32 bit odbc setting give a name to the file dsn locate database and server and even we have option to test it.
then specify the file dsn name in code to open connection.
it works if tested at the odbc settings.

regards
Martin
0
 
nigelroweCommented:
I don't know if this what you're looking for but here goes...

You can export the Windows registry values for all of the DSN's on your machine to a .REG file. You can then merge this file into the registry of another machine. However, be aware that the driver filepath for each entry is included in this file, so you have to edit this file, before merging, to be sure that it reflects the filepath on the other machine.

To do this, run regedit, search for ODBC (Match whole string only). When it is found, click on registry, click on export registry file and follow the instructions which follow.

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
mcoopCommented:

I've used this succesfully with a pre-existing fileDSN...

dim cn As ADODB.connection
cn.open "fileDSN=myDSNname"

etc
0
 
Valliappan ANSenior Tech ConsultantCommented:
ping..
0
 
sureshpodarallaCommented:
Set cnn = New ADODB.Connection
cnn.Open "DSN=" & sOraDsn & ";UID=" & sUser & ";PWD=" & sPassWord

Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient


rst.Open "Select * from Table1 where Col1= " & strFiled1, cnn, adOpenStatic, adLockOptimistic

I hope this will help you.

Thanks,
Suresh Podaralla
0
 
mcoopCommented:
sureshpodaralla...

Your solution is not correct for a
0
 
mcoopCommented:
Oops... !

sureshpodaralla , your code is not correct for a fileDSN as requested.  The DSN= parameter is for 'machine' DSN's

(I've tried it before, and only found the fileDSN= pram by good fortune !)

Cheers

You are correct though... if the fileDSN doesn't have the UID= and PWD= params filled in, then you do need to pass them in the .Open function.

BTW: to answer the second part of the original question,
DSN's are stored in \Program Files\COmmon Files\ODBC\Data Sources.  You can open and edit them with a text editor, or use a wizard (eg in Access) to manipulate them.



0
 
VBSysCOM1Commented:
   Dim cn As ADODB.Connection
    Dim rs As ADODB.Recordset
    Dim sCN As String
    Screen.MousePointer = vbHourglass
    sCN = "Provider=MSDASQL.1;Persist Security & _  
    Info=False;Data Source=DSNFILE;Mode=ReadWrite; & _
    Initial Catalog=DATABASE"
    Set cn = New ADODB.Connection
    cn.ConnectionString = sCN
    cn.Open


Here You Go I Hope This Helpsw


Have A Good Day!
0
 
mcoopCommented:


I don't think that krs_rama is still listening....
0
 
krs_ramaAuthor Commented:
simple and good answer.. works out.. thanks !!! krs_rama
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now