1055:
36:
1045:
480:
module, each driver has its own syntax for the DSN attributes. The only requirement that DBI makes is that all the information, except for username and password is supplied in a single string argument.
291:
Software (e.g., Crystal
Reports, Microsoft Excel, PHP, Perl, Python, Ruby) users can submit CRUD (Create, Read, Update, Delete) queries to a data source by establishing a connection to the DSN.
360:
using the PEAR::DB package to open a connection without an external DSN (a "DSN-less connection", i.e., using a
Connection String), the code might resemble the following
950:
243:– stored in collective configuration files (e.g., /etc/odbc.ini, ~/.odbc.ini) and/or system resources (e.g., Windows Registry HKLM\Software\ODBC\odbc.ini)
847:
980:
790:
633:
965:
662:
1048:
1078:
119:
53:
100:
174:". Most systems do not make a distinction between DSNs or connection strings and the term can often be used interchangeably.
975:
960:
72:
57:
889:
843:
996:
221:
955:
810:
757:
79:
622:
868:
752:
377://$ dsn = "<driver>://<username>:<password>@<host>:<port>/<database>";
1011:
884:
780:
700:
155:
86:
46:
970:
775:
205:
The system administrator of a client machine generally creates a separate DSN for each relevant data source.
68:
905:
853:
742:
655:
927:
260:– accessible by any and all processes and users of the system, stored in a centralized location (e.g.,
1001:
863:
720:
1021:
725:
225:
1058:
942:
932:
820:
213:
1026:
1006:
825:
802:
648:
171:
93:
274:– accessible only by the user who created the DSN, stored in a user-specific location (e.g.,
915:
735:
705:
27:
String that has an associated data structure used to describe a connection to a data source
910:
858:
835:
747:
715:
710:
690:
195:
188:
922:
815:
785:
695:
159:
162:
used to describe a connection to a data source. Most commonly used in connection with
1072:
151:
1031:
209:
35:
17:
730:
584:
1016:
135:
767:
685:
671:
477:
295:
132:
589:
604:
507:"DBI:mysql:database=$ database;host=$ hostname;port=$ port"
170:
and for other data access mechanisms. The term often overlaps with "
495:"DBI:Pg:database=finance;host=db.example.com;port=$ port"
599:
594:
473:
167:
163:
644:
298:) code to open a DSN connection might look like the following:
228:) can take advantage of this in accessing shared data sources.
357:
217:
29:
640:
519:"DBI:Oracle:host=$ host;sid=$ sid;port=$ port"
177:
DSN attributes may include, but are not limited to:
989:
941:
898:
877:
834:
801:
766:
678:
279:
275:
265:
261:
60:. Unsourced material may be challenged and removed.
386:"mysql://john:pass@localhost:3306/my_db"
249:– stored in the filesystem with one DSN per file
431:"mysql:host=localhost;dbname=example"
656:
201:a user password for data access (if required)
154:" can comprise other repositories apart from
8:
663:
649:
641:
531:"DBI:SQLite:dbname=$ dbfilename"
120:Learn how and when to remove this message
615:
266://etc/odbc_file_dsns/<filename>
212:; various applications (for example:
208:Standardizing DSNs offers a level of
158:) is a string that has an associated
7:
58:adding citations to reliable sources
1044:
253:These are further broken down into
280:/~/odbc_file_dsns/<filename>
25:
1054:
1053:
1043:
191:which can access the data source
34:
184:the location of the data source
45:needs additional citations for
1:
997:Database-centric architecture
198:for data access (if required)
330:"ADODB.Connection"
634:ODBC DSN connection strings
181:the name of the data source
1095:
1012:Locks with ordered sharing
844:Entities and relationships
701:Database management system
1040:
890:Object–relational mapping
623:Connection String and DSN
232:Types of data source name
1079:Data access technologies
483:
422:
362:
348:"DSN=example;"
300:
236:Two kinds of DSN exist:
146:, sometimes known as a
166:, DSNs also exist for
791:information retrieval
1002:Intelligent database
148:database source name
54:improve this article
811:Activity monitoring
981:Online real estate
570:'password'
564:'username'
371:"DB.php"
69:"Data source name"
1066:
1065:
1027:Halloween Problem
1007:Two-phase locking
966:Facial expression
885:Abstraction layer
826:Negative database
781:Data manipulation
172:connection string
130:
129:
122:
104:
16:(Redirected from
1086:
1057:
1056:
1047:
1046:
665:
658:
651:
642:
636:
631:
625:
620:
574:
571:
568:
565:
562:
559:
556:
553:
550:
547:
544:
541:
538:
535:
532:
529:
526:
523:
520:
517:
514:
511:
508:
505:
502:
499:
496:
493:
490:
487:
468:
465:
462:
459:
456:
453:
450:
447:
444:
441:
438:
435:
432:
429:
426:
414:
411:
408:
405:
402:
399:
396:
393:
390:
387:
384:
381:
378:
375:
372:
369:
366:
352:
349:
346:
343:
340:
337:
334:
331:
328:
325:
322:
319:
316:
313:
310:
307:
304:
281:
277:
267:
263:
140:data source name
125:
118:
114:
111:
105:
103:
62:
38:
30:
21:
18:Data Source Name
1094:
1093:
1089:
1088:
1087:
1085:
1084:
1083:
1069:
1068:
1067:
1062:
1036:
985:
937:
894:
873:
830:
797:
776:Data definition
762:
674:
669:
639:
632:
628:
621:
617:
613:
581:
576:
575:
572:
569:
566:
563:
560:
557:
554:
551:
548:
545:
542:
539:
536:
533:
530:
527:
524:
521:
518:
515:
512:
509:
506:
503:
500:
497:
494:
491:
488:
485:
470:
469:
466:
463:
460:
457:
454:
451:
448:
445:
442:
439:
436:
433:
430:
427:
424:
416:
415:
412:
409:
406:
403:
400:
397:
394:
391:
388:
385:
382:
379:
376:
373:
370:
367:
364:
354:
353:
350:
347:
344:
341:
338:
336:DatabaseObject1
335:
332:
329:
326:
323:
320:
317:
314:
312:DatabaseObject1
311:
308:
306:DatabaseObject1
305:
302:
289:
234:
189:database driver
126:
115:
109:
106:
63:
61:
51:
39:
28:
23:
22:
15:
12:
11:
5:
1092:
1090:
1082:
1081:
1071:
1070:
1064:
1063:
1041:
1038:
1037:
1035:
1034:
1029:
1024:
1019:
1014:
1009:
1004:
999:
993:
991:
987:
986:
984:
983:
978:
973:
968:
963:
958:
953:
947:
945:
939:
938:
936:
935:
930:
925:
920:
919:
918:
908:
906:Virtualization
902:
900:
896:
895:
893:
892:
887:
881:
879:
875:
874:
872:
871:
866:
861:
856:
851:
840:
838:
832:
831:
829:
828:
823:
818:
813:
807:
805:
799:
798:
796:
795:
794:
793:
783:
778:
772:
770:
764:
763:
761:
760:
755:
750:
745:
740:
739:
738:
733:
723:
718:
713:
708:
703:
698:
693:
688:
682:
680:
676:
675:
670:
668:
667:
660:
653:
645:
638:
637:
626:
614:
612:
609:
608:
607:
602:
597:
592:
587:
580:
577:
484:
423:
420:PHP with PDO.
363:
301:
288:
287:Example of use
285:
284:
283:
269:
251:
250:
244:
233:
230:
203:
202:
199:
192:
187:the name of a
185:
182:
160:data structure
128:
127:
42:
40:
33:
26:
24:
14:
13:
10:
9:
6:
4:
3:
2:
1091:
1080:
1077:
1076:
1074:
1061:
1060:
1051:
1050:
1039:
1033:
1030:
1028:
1025:
1023:
1020:
1018:
1015:
1013:
1010:
1008:
1005:
1003:
1000:
998:
995:
994:
992:
988:
982:
979:
977:
974:
972:
969:
967:
964:
962:
959:
957:
954:
952:
949:
948:
946:
944:
940:
934:
931:
929:
926:
924:
921:
917:
914:
913:
912:
909:
907:
904:
903:
901:
897:
891:
888:
886:
883:
882:
880:
876:
870:
867:
865:
862:
860:
857:
855:
854:Normalization
852:
849:
845:
842:
841:
839:
837:
833:
827:
824:
822:
819:
817:
814:
812:
809:
808:
806:
804:
800:
792:
789:
788:
787:
784:
782:
779:
777:
774:
773:
771:
769:
765:
759:
756:
754:
751:
749:
746:
744:
743:Administrator
741:
737:
734:
732:
729:
728:
727:
724:
722:
719:
717:
714:
712:
709:
707:
704:
702:
699:
697:
694:
692:
689:
687:
684:
683:
681:
677:
673:
666:
661:
659:
654:
652:
647:
646:
643:
635:
630:
627:
624:
619:
616:
610:
606:
603:
601:
598:
596:
593:
591:
588:
586:
583:
582:
578:
482:
479:
475:
421:
418:
361:
359:
299:
297:
292:
286:
273:
270:
262:/etc/odbc.ini
259:
256:
255:
254:
248:
245:
242:
239:
238:
237:
231:
229:
227:
223:
219:
215:
211:
206:
200:
197:
193:
190:
186:
183:
180:
179:
178:
175:
173:
169:
165:
161:
157:
153:
149:
145:
141:
137:
134:
124:
121:
113:
102:
99:
95:
92:
88:
85:
81:
78:
74:
71: –
70:
66:
65:Find sources:
59:
55:
49:
48:
43:This article
41:
37:
32:
31:
19:
1052:
1042:
1032:Log shipping
976:Online music
961:Biodiversity
928:Preservation
686:Requirements
629:
618:
476:, using the
471:
419:
417:
365:require_once
355:
324:CreateObject
293:
290:
276:/~/.odbc.ini
271:
257:
252:
246:
241:Machine DSNs
240:
235:
207:
204:
176:
152:data sources
147:
143:
139:
131:
116:
107:
97:
90:
83:
76:
64:
52:Please help
47:verification
44:
1049:WikiProject
878:Programming
869:Cardinality
864:Refactoring
721:Application
258:System DSNs
210:indirection
1022:Publishing
956:Biological
899:Management
731:datasource
726:Connection
611:References
585:Datasource
464:$ password
458:$ username
150:, though "
110:April 2022
80:newspapers
1017:Load file
933:Integrity
923:Migration
850:notation)
821:Forensics
768:Languages
272:User DSNs
247:File DSNs
156:databases
136:computing
1073:Category
1059:Category
990:See also
951:Academic
943:Lists of
848:Enhanced
803:Security
672:Database
579:See also
478:Perl DBI
296:VBScript
916:caching
706:Machine
590:ADO.NET
552:connect
404:connect
196:user ID
94:scholar
971:Online
911:Tuning
859:Schema
836:Design
716:Server
711:Engine
696:Models
691:Theory
605:OLE DB
318:Server
214:Apache
96:
89:
82:
75:
67:
846:(and
816:Audit
786:Query
758:Tools
753:Types
558:$ dsn
549:->
540:$ dbh
525:$ dsn
513:$ dsn
501:$ dsn
489:$ dsn
452:$ dsn
437:$ dbh
425:$ dsn
410:$ dsn
380:$ dsn
294:ASP (
101:JSTOR
87:books
748:Lock
679:Main
600:ODBC
595:JDBC
474:Perl
392:$ db
342:Open
220:and
168:JDBC
164:ODBC
138:, a
73:news
736:DSN
546:DBI
472:In
446:PDO
443:new
358:PHP
356:In
309:Set
303:Dim
226:ASP
222:IIS
218:PHP
144:DSN
56:by
1075::
573:);
537:my
486:my
467:);
413:);
401:::
398:DB
374:);
278:,
264:,
194:a
133:In
664:e
657:t
650:v
567:,
561:,
555:(
543:=
534:;
528:=
522:;
516:=
510:;
504:=
498:;
492:=
461:,
455:,
449:(
440:=
434:;
428:=
407:(
395:=
389:;
383:=
368:(
351:)
345:(
339:.
333:)
327:(
321:.
315:=
282:)
268:)
224:/
216:/
142:(
123:)
117:(
112:)
108:(
98:·
91:·
84:·
77:·
50:.
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.