09-18-2001
Hi Eddie
Thanks a lot for your reply.
I have source code with me, and it is written in C++, it uses MFC classes to read registry, and has embedded ODBC SQL statements , and it is running fine On NT OS, Now I think I have clarifed doubts, for anything else pls do write back.
Thanks in advance
10 More Discussions You Might Find Interesting
1. Programming
Hello,
I am a VC++ programmer. I want to port my existing , working VC++ application on windows NT using MS-Word on to Unix as an OS....
My requirement is just to port the server part of the application on UNIX and client part would remain in NT.
I have many issues to handle to finally... (1 Reply)
Discussion started by: real_rachna
1 Replies
2. Programming
I have source code of a Windows C DLL. It complies properly and works. Now I need to port it to UNIX environment.
I need to know if I can create a Dynamic Library or only Static Library is possible in UNIX.
In case I can create a Dynamic Library please guide me how to proceed. Or if there... (2 Replies)
Discussion started by: ana_puri
2 Replies
3. UNIX for Advanced & Expert Users
Can anybody help me in finding out a solution for the problem below?
When we write .unix or .sh files in windows OS and port them to Unix platforms there is a character ^M inserted at the end of each line of the script file.
During ftp porting I set the transfer mode as ASCII for the script... (7 Replies)
Discussion started by: tamilselvi
7 Replies
4. Programming
We are in requirement to port relative file organization files from OpenVMS V7.1-1H2 to AIX Unix. These file contains multiple binary records each of 512 bytes but it could be possible that a few bytes are padded up to fill the record structure.
One of our thought process is to write a program... (1 Reply)
Discussion started by: S.P.Prasad
1 Replies
5. UNIX for Advanced & Expert Users
My question is: difference between unix and linux in terms of compiler, file system, ANSI
compliance, standard liabrary issues, threading issues, operating system
calls memory issues..ie whether these things wud cause problems while
porting a unix programme to linux.?
I think answer is depend... (1 Reply)
Discussion started by: prasoon
1 Replies
6. UNIX for Dummies Questions & Answers
Hi
I have a rather large set of sas programs that i want to port to unix sas.
All of these programs uses windows functionality somehow. For example win API calls and ole-dll:s via com and dcom.
Now my company is moving to sas on unix, and we must port these apps (sas macros).
So what Im... (3 Replies)
Discussion started by: iommi
3 Replies
7. UNIX for Advanced & Expert Users
Is it possible for a Unix script to execute a .dll. If so, where would I find information/examples of how to do that?
Thanks, in advance, for any help. :rolleyes: (2 Replies)
Discussion started by: BCarlson
2 Replies
8. What is on Your Mind?
I have created DLLs in c++. Is it possible to run these DLLs in unix so that I can save time converting function/scripts in unix? In this way I can reuse these DLL in Unix. Thanks. (2 Replies)
Discussion started by: alestoquia
2 Replies
9. Programming
Hello,
I am sorry to bother you all but I am thinking about switching to UNIX and I am a complete novice there.
The problem is that I need to call a C++ dll on UNIX platform which was compiled on Windows. I don't have the source code of the dll as well. I just need to call this dll in my C++... (2 Replies)
Discussion started by: clickoo
2 Replies
10. UNIX for Dummies Questions & Answers
Hi...
I have build a program for the Velleman K8000 interface card, in java, which works just fine in windows, but now I want to use the program on a Unix-System.
Is it possible to somehow convert the dll file to a format that Unix supports, or do I have to find another way?
Dll-file:... (3 Replies)
Discussion started by: Scorp-D
3 Replies
LEARN ABOUT DEBIAN
grass-odbc
grass-odbc(1grass) Grass User's Manual grass-odbc(1grass)
NAME
grass-odbc - ODBC driver
ODBC driver ODBC driver in GRASS Communication between GRASS and ODBC database for attribute management:
| GRASS module | | ODBC Interface | | RDBMS
| GRASS | DBMI driver | unixODBC | ODBC driver | PostgreSQL
| Oracle
| ...
Supported SQL commands
All SQL commands supported by ODBC.
Operators available in conditions
All SQL operators supported by ODBC.
EXAMPLE
In this example we copy the dbf file of a SHAPE map into ODBC, then connect GRASS to the ODBC DBMS. Usually the table will be already
present in the DBMS.
Configure ODBC driver for selected database (manually or with 'ODBCConfig'). ODBC drivers are defined in /etc/odbcinst.ini.
Here is example:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
Create DSN (data source name). The DSN is used as database name in db.* modules. Then DSN must be defined in
$HOME/.odbc.ini (for this user only) or in /etc/odbc.ini for (for all users) [watch out for the database name which appears
twice and also for the PostgreSQL protocol version]. Omit blanks at the beginning of lines:
[grass6test]
Description = PostgreSQL
Driver = PostgreSQL
Trace = No
TraceFile =
Database = grass6test
Servername = localhost
UserName = neteler
Password =
Port = 5432
Protocol = 8.0
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings = Configuration of an DSN without GUI is described on http://www.unixodbc.org/odbcinst.html, but
odbc.ini and .odbc.ini may be created by the 'ODBCConfig' tool. You can easily view your DSN structure by 'DataManager'. Con-
figuration with GUI is described on http://www.unixodbc.org/doc/UserManual/
To find out about your PostgreSQL protocol, run:
psql -V
Now create a new database if not yet existing:
db.createdb driver=odbc database=grass6test
Now store the table 'mytable.dbf' (here: in current directory) into PostgreSQL through ODBC:
db.connect driver=odbc database=grass6test
db.copy from_driver=dbf from_database=./ from_table=mytable
to_driver=odbc to_database=grass6test to_table=mytable
Next link map to attribute table (now the ODBC table is used, not the dbf file):
v.db.connect map=mytable.shp table=mytable key=ID
database=grass6test driver=odbc
v.db.connect -p
Finally a test: Here we should see the table columns (if the ODBC connection works):
db.tables -p
db.columns table=mytable
Now the table name 'mytable' should appear.
Doesn't work? Check with 'isql ' if the ODBC-PostgreSQL connection is really established.
Note that you can also connect mySQL, Oracle etc. through ODBC to GRASS. You can also check the vector map itself concerning a current
link to a table:
v.db.connect -p mytable.shp
which should print the database connection through ODBC to the defined RDBMS.
SEE ALSO
db.connect, v.db.connect, unixODBC web site, SQL support in GRASS GIS
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-odbc(1grass)