this is sanjay
presently i am doing a project on java which has backend as instant db but i want to replace it with access and things should be done dynamically.if any help plz mail me asap
I need My client to connect to sql server using ODBC using the function SQLConfigDataSource every thing is OK but I can't specify user and password for this connection ...
When not writting UID,PWD attributes ,An authentication Dialog box displayed for asking the user to verify the user and password....and it's not desired to display such a message...
I need Help....PLZ
When I create a DSN for SQL Server everything works fine, except a UID and PWD is specified. If they are not specified registration succeeds using Win NT Login as the Login for SQL Server. Has anybody tried this?
How can i see a report from access in VC++ using ADO?
I don't no very well how reports do, but what i want is to execute querys from VC++ in reports from access.
I can do it in tables but i don't no if it's possible to do it in reports.
This is Suji
I am Using MS Access 2000 as Backend for Java Applications.
If you have any idea on Ms Access DataTypes those will be used in Java Programming pl tell me.
Or if u found any web page contains brief Description about Ms Access 2000 Datatypes pl suggest me
the code works perfect.
however there was something overlooked. the ':' is being replaced by a '\0'.
the path to databse may contain a ':'. this will also be replaced by a '\0'. thus the path would not be specified correctly.
here the change has to be made. replace the':' by any other char which is not likely to be included in the database path.
i am giving the modified version:
sprintf(szDesc,"DSN=%s$ DESCRIPTION=Client data$ DBQ=%s$FIL=MicrosoftAccess$ :: ","Client",argv);
mlen = strlen(szDesc);
for (int i=0; i<mlen; i++)
if (szDesc[i] == '$') szDesc[i] = '\0';
if (FALSE ==SQLConfigDataSource(NULL,ODBC_ADD_DSN,"Microsoft Access Driver (*.mdb)\0",(LPCSTR)szDesc))
printf("DSN Creation Failure");
// code was run from cmd prompt
printf("DSN Creation Successful");