[Pdns-users] PowerDNS and MsSQL

[Patricio Valdes]

We have successfully launched PowerDNS with ODBC and MsSQL. We want to
migrate to godbc and MsSQL.

Unfortunately we have been unable to get it to work. We can connect to MsSQL
without a problem. We can also make it work with Access DB but when
switching the ODBC datasource to MsSQL we get the following errors:

PowerDNS 2.9.6-WIN32 (Feb 16 2003, 20:37:14) starting up
GENERAL PUBLIC LICENSE (GPL)
PowerDNS 2.9.6-WIN32 (Feb 16 2003, 20:37:14) starting up
Creating backend connection for TCP
Launched webserver on 127.0.0.1:8081
godbc Connection succesful
About to create 3 backend threads
godbc Connection succesful
godbc Connection succesful
godbc Connection succesful
Done launching threads, ready to distribute questions
Caught unknown exception in Distributor thread 3100680
Caught unknown exception in Distributor thread 3100944
Distributor misses a thread (2<3), spawning new one
godbc Connection succesful
Authoritative empty NO ERROR to 208.204.150.215 for 'www.maldivez.com' (A),
othe
r types do exist

Any ideas? Thanks.

Patricio Valdes
Parava Networks

-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com]On Behalf Of Norbert
Sendetzky
Sent: Monday, July 07, 2003 1:07 PM
To: Ryan Baldwin; pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] records.change_date field


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 07 July 2003 16:46, Ryan Baldwin wrote:
> Hrmmm... if I'm going to do a date/time format in int notation, I'd
> love to be able to do YYYYMMDDHHMMSS, but that would require me
> using the "bigint" field type in sql server... does anybody know if
> pdns would accept the changes from "int" to "bigint" for free?  ie,
> can it handle big int (bigint fields are 8 bytes)

No, it can't. SOA serial is u_int32_t.


Norbert

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj8JtuYACgkQxMLs5v5/7eC5vACgieVnZoHPwQj0QJ7cAPI2LZA8
rBUAnRcwaS1pzyAIRU8HPWFG206k5ZfV
=GrU3
-----END PGP SIGNATURE-----

_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users