Caller ID - support

Support forums (swedish / english)

The database table structure is supposed to look something like this.

caller_id
    id (integer, identifier)
    caller_id (varchar,25)
    call_when (varchar,20)

CREATE TABLE caller_id ( id int not NULL identity (1, 1), caller_id varchar (25) NULL, call_when varchar (20) NULL, PRIMARY KEY(id) )

Connection strings:
MS SQL : Driver={SQL Server}; Server=(local); Database=myDb; Uid=myUsername; Pwd=myPassword
MS SQL (remote) : Driver={SQL Server}; Server=xxx.xxx.xxx.xxx; Address=xxx.xxx.xxx.xxx,1433; Network=DBMSSOCN; Database=myDb; Uid=myUsername; Pwd=myPassword
MySQL : Driver={mySQL}; Server=myServer; Option=16834; Database=myDb
MySQL (remote) : Driver={mySQL}; Server=myServer; Port=3306; Option=131072; Stmt=; Database=myDb; Uid=myUsername; Pwd=myPassword
MySQL (ODBC driver) : Driver={MySQL ODBC 3.51 Driver}; Server=myServer; Port=3306; Option=131072; Stmt=; Database=myDb; Uid=myUsername; Pwd=myPassword
Access (.mdb) : Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\cid.mdb; Uid=admin; Pwd=
Excel (.xls) : Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\cid.xls; Extended Properties=Excel 8.0

MySQL in not working, what's the problem?

You may need to download a ODBC driver for MySQL.

[http://www.mysql.com/downloads/api-myodbc.html]

How do I know if my modem supports Caller ID?

The modem has to work with your country's standard.
PowerBit/Surfinbird (some models) are the only modems that support the swedish standard.

[http://www.intertex.se/] - [http://www.surfinbird.nu/]

What will I do with all the numbers stored in the database?

Well... it's up to you.
Can I check if my modem supports Caller ID?

Yes, try this.
Use a terminal program, ie. Hyper Terminal.
AT#CID? - reports current Caller ID mode.
AT#CID=? - reports available modes
AT#CID=1 - turns Caller ID on manually. 0 to turn off.
For most MODEMs, the string AT#CID=1 will enable Caller ID. On some voice based MODEMs the string is AT#CLS=8#CID=1. Look in the user's manual for your MODEM to see if any setup string is referenced or mentioned.

Other common setup strings are:
* AT#CID=2
* AT%CCID=1
* AT%CCID=2
* AT+VCID=1
* AT#CC1
* AT*ID1


ToDo list

contact

back to first page