create data source name (DSN) from command line

[Mohammed Seidu]

I need to create DSN from command line or command prompt for the deployment of my application.

Any help would be appreciated.

Thank you all in advance.

[balabaster]

I need to create DSN from command line or command prompt for the deployment of my application.

Any help would be appreciated.

Thank you all in advance.

Could you not specify the connectionstring in your app.config instead of using a preformed DSN? It seems that this is a more convenient way of managing it. You would then specify connection settings in your application's setup?

If not, then it can be done programmatically - I don't think there's a command line tool for creating a DSN, however, you could write one in .NET using the technique found at:

http://support.microsoft.com/kb/q184608/

The code in this document is for VB, but it could easily be adapted to write a .NET console application which could in turn be used to create DSNs from the command line.

[Mohammed Seidu]

Thank you.
The actual problem is, I am connecting to a dsn through crystal report for the creation of my reports. I am thus worried about how the deployment is going to be without manually creating a dsn in the deployment environment.
Is there away to automate that process?
Personally I don't like the idea of connecting to a dsn to design my reports but tried connecting to the database directly (access database) but unsuccessful. I would be glad if you can help me complete this form:
Database Name: .....................
Database Type:....Access
User ID:....Admin
Password: ...............
Jet System Database: .........
Jet Database Password: ................

Could you not specify the connectionstring in your app.config instead of using a preformed DSN? It seems that this is a more convenient way of managing it. You would then specify connection settings in your application's setup?

If not, then it can be done programmatically - I don't think there's a command line tool for creating a DSN, however, you could write one in .NET using the technique found at:

http://support.microsoft.com/kb/q184608/

The code in this document is for VB, but it could easily be adapted to write a .NET console application which could in turn be used to create DSNs from the command line.

[Mohammed Seidu]

Thank you all.
I finally was enable to connect to my access database through crystal report.
The database name: is the path to the database file
User ID: not neccessary
Password: not neccessary
Jet System database: C:\Documents and Settings\Administrator\Application Data\Microsoft\Access\System.mdw
Jet Database password: password of access file

I am now working on trying to display the crystal report in my application (connecting to the tables involved at run time).
Any help would be welcomed.

Thank you.
The actual problem is, I am connecting to a dsn through crystal report for the creation of my reports. I am thus worried about how the deployment is going to be without manually creating a dsn in the deployment environment.
Is there away to automate that process?
Personally I don't like the idea of connecting to a dsn to design my reports but tried connecting to the database directly (access database) but unsuccessful. I would be glad if you can help me complete this form:
Database Name: .....................
Database Type:....Access
User ID:....Admin
Password: ...............
Jet System Database: .........
Jet Database Password: ................

[Mohammed Seidu]

The new problem is when I run the report, a get a form asking me to complete the form below:

ServerName: C:\\test.mdb
Database:
Login ID: Admin
Password:

I have entered the database password a number of times but failed to connect the table involved to make the report visible

Thank you all.
I finally was enable to connect to my access database through crystal report.
The database name: is the path to the database file
User ID: not neccessary
Password: not neccessary
Jet System database: C:\Documents and Settings\Administrator\Application Data\Microsoft\Access\System.mdw
Jet Database password: password of access file

I am now working on trying to display the crystal report in my application (connecting to the tables involved at run time).
Any help would be welcomed.