On Mon, Oct 14, 2002 at 01:57:28PM +0200, Roger Perttu wrote: > Thomas A. Lowery wrote: > > However nothing(!) seem to work for me with DBD-ADO (Using MS SQL 7.0 > MDAC 2.7 DBI 1.30 Activeperl 631): > > my $dbh = newDbh();
Of course my set-up is different, I just tested a remote connect to my local nt system running ms sql 6.5 ... it works fine for me. What does the code for newDbh look like? This is my connect string: set DBI_DSN=dbi:ADO:Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=pubs;Data Source=STLNTWK1 T:\DBD-ADO>dbish DBI::Shell 11.02 using DBI 1.28 WARNING: The DBI::Shell interface and functionality are ======= very likely to change in subsequent versions! Connecting to 'dbi:ADO:Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=pubs;Data Source=STLNTWK1' as 'tlowery'... Data Source=STLNTWK1> /tab TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS 'pubs','dbo','sysalternates','SYSTEM TABLE',undef 'pubs','dbo','sysarticles','SYSTEM TABLE',undef 'pubs','dbo','syscolumns','SYSTEM TABLE',undef 'pubs','dbo','syscomments','SYSTEM TABLE',undef 'pubs','dbo','sysconstraints','SYSTEM TABLE',undef 'pubs','dbo','sysdepends','SYSTEM TABLE',undef 'pubs','dbo','sysindexes','SYSTEM TABLE',undef 'pubs','dbo','syskeys','SYSTEM TABLE',undef 'pubs','dbo','syslogs','SYSTEM TABLE',undef 'pubs','dbo','sysobjects','SYSTEM TABLE',undef 'pubs','dbo','sysprocedures','SYSTEM TABLE',undef 'pubs','dbo','sysprotects','SYSTEM TABLE',undef 'pubs','dbo','syspublications','SYSTEM TABLE',undef 'pubs','dbo','sysreferences','SYSTEM TABLE',undef 'pubs','dbo','syssegments','SYSTEM TABLE',undef 'pubs','dbo','syssubscriptions','SYSTEM TABLE',undef 'pubs','dbo','systypes','SYSTEM TABLE',undef 'pubs','dbo','sysusers','SYSTEM TABLE',undef 'pubs','dbo','authors','TABLE',undef 'pubs','dbo','demo','TABLE',undef 'pubs','dbo','discounts','TABLE',undef 'pubs','dbo','employee','TABLE',undef 'pubs','dbo','jobs','TABLE',undef 'pubs','dbo','pub_info','TABLE',undef 'pubs','dbo','publishers','TABLE',undef 'pubs','dbo','roysched','TABLE',undef 'pubs','dbo','sales','TABLE',undef 'pubs','dbo','stores','TABLE',undef 'pubs','dbo','titleauthor','TABLE',undef 'pubs','dbo','titles','TABLE',undef 'pubs','tlowery','dbd_ado_large','TABLE',undef 'pubs','tlowery','perl_dbd_ado_long','TABLE',undef 'pubs','tlowery','PERL_DBD_TEST','TABLE',undef 'pubs','dbo','titleview','VIEW',undef [34 rows of 5 fields returned] -- Thomas A. Lowery See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
