Hi all, to create a user that is able to connect via *DBC (ODBC. JDBC) just do this few step: ON SERVER: 1. be sure the sapdb server is running: >Linux: go in: /opt/sapdb/indep_prog/bin/ and lunch: ./x_server >if you have permission error you have to go in /usr/spool/sql/ipc and create to folder: db and us with sapdb group permission); try to restart ./x_server
2. be sure your database is running: >Linux: go in: /opt/sapdb/indep_prog/bin/ and lunch: ./dbmcli -d TST -u dbm, dbm; db_start; db_online;) ON CLIENT (WINDOWS): 3. Lunch sqlStudio and connect to the database: >Windows sqlStudio: >Server:192.168.0.1 (or other ip also the local machine: 127.0.0.1) >Database:TST >Username:DBA >Password:DBA 4. Create a new standard user: >Windows sqlStudio: Menu View->SQL Dialog, appear a new window, type: CREATE USER maxsoft PASSWORD maxsoft 5. Create an ODBC source: >Control Pannel->ODBC->Add->SAPDB 7.x >Data Source Name: as you like (I've put: SAPDBTST) >Description: as you like (I've put: Database SAPDB Demo) >Database: TST >Server: the same ip of the step 3 (192.168.0.1 or other or local machine 127.0.0.1) 6. Test your connection: >Visual Basic sample: Private Sub Command1_Click() Dim cn As New ADODB.Connection cn.Open "DSN=TST", "massimo", "massimo" Debug.Print cn.State 'have to write: 1 end sub thank you Markus for all patient, I hope to have done a usefully e-mail for all new SAPDB user. (next guide: how to in Linux Mandrake; how to define user group; how to set special permission to the objects) bye all maxsoft irc-chat: server address: LasVegas.NV.US.Undernet.org server port: 6667 channel: #sapdb _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
